Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> How to make use of the data in a cursor returned from a stored
Hi,
I am new to oracle stored procedure.
I have written a stored procedure which returns a cursor. I am trying to write a corresponding test program to verify the cursor output.
The stored procedure is
PackClientCashLedger.GetCashLedgerRecord(ioSeverity, ioErrorMsg, cur,
'0001');
which cur is the returned cursor with firm_id as one of the field.
The testing program is as follows,
declare
cur types.cursortype;
c varchar2(4000);
ioSeverity varchar2(20);
ioErrorMsg varchar2(20);
begin
dbms_output.enable(1000000);
PackClientCashLedger.GetCashLedgerRecord(ioSeverity, ioErrorMsg,
cur, '0001');
for cur_rec in cur
loop dbms_ouput.put_line(cur_rec.firm_id); end loop;
which returns the error when ran,
ERROR at line 13:
ORA-06550: line 13, column 17: PLS-00221: 'CUR' is not a procedure or is undefined ORA-06550: line 13, column 2:
Thanks in advance for any input,
Wing Received on Wed Jul 31 2002 - 20:10:38 CDT