>>the rowcount gives always 0 irrespective of input passed.
That is because the %ROWCOUNT returns the number of rows that you have
processed SO FAR. So after you open the cursor, the rowcount is going to
give you zero. You have to fetch the next row before ROWCOUNT will
increment.


Thanks...
Chris


Oracle Engineering
[Email address protected]
224.405.0368




"Gururaj " <oracledba-ezmlmshield-x27934030.[Email address protected]
05/31/04 06:17 PM


To: "LazyDBA.com Discussion" <[Email address protected]
cc:
Subject: URGENT. PLZ HELP.. LOOPING THRU RECORDS IN REFCURSOR


Hi Oracle Gurus,


I am executing stored procedure from an anonymous pl-sql block,
where i am getting the REF CURSOR as output parameter.

Now i want to loop through all the records in the refcursor.

DECLARE
CUR_TYPE PKG_TYPES.CURSOR_TYPE; -- REFCURSOR declared in
package.
BEGIN
SP_FETCHFEEBACKTRNDET('M9999','T002/M01','BT1',CUR_TYPE); -- Should
return records
DBMS_OUTPUT.PUT_LINE(CUR_TYPE%ROWCOUNT); -- NOT WORKING
END;

the rowcount gives always 0 irrespective of input passed.

THANKING IN ADVANCE

REGARDS
GURU




!-- Virus-Free Mail Using PostMaster Enterprise AvAc & QuickHeal Engine
--!

----------------------------------------------------------------
Bluechip Computer Consultants Pvt Ltd, Bangalore, India
Sent using PostMaster by QuantumLink Communications Pvt Ltd
One Internet account, unlimited personal e-mail addresses
Get your free copy of PostMaster at http://www.postmaster.co.in/


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page