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/

Oracle LazyDBA home page