Re: Table Function in Open For

From: Hans <forbrich_at_gmail.com>
Date: 7 Oct 2004 12:21:12 -0700
Message-ID: <bd0e88c6.0410071121.a2417d8@posting.google.com>

claudia.przioda_at_gmx.de (Claudy) wrote in message news:<7c101571.0410040854.2a3c472d_at_posting.google.com>...
> Hello,
>
> I'm a PL/SQL beginner and I would like launch a procedure that call a
> table function with dynamicals parameters. But I receive no error and
<snip>
>
> --But Sucherg_cur%ROWCOUNT=0 -> WHY?????????????????
> --lcSelect has expected value
> Dbms_Output.PUT_LINE(To_Char(Sucherg_cur%ROWCOUNT));

Perhaps the following definition, from Oracle's documentation, will help understanding this:

%ROWCOUNT Attribute
This is a cursor attribute that can be appended to the name of a cursor or cursor variable. When a cursor is opened, %ROWCOUNT is zeroed. Before the first fetch, cursor_name%ROWCOUNT yields 0. Thereafter, it yields the number of rows fetched so far. The number is incremented if the latest fetch returned a row.

That came from Chapter 13 of the PL/SQL Reference manual, available at http://docs.oracle.com ... Fore Oracle9iR2 the reference is http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/13_elems12.htm#33379

/Hans Received on Thu Oct 07 2004 - 14:21:12 CDT