trying to test a procedure with a cursor, help
Hi, I have a procedure on the database that returns a cursor, here is a snippet:
procedure test_rows(page1 IN number,
page2 IN number,
test_cursor_rtn out test_cursor);
I declared the cursor as type REF CURSOR and all that good stuff...
Now I want to test it, this doesn't work:
declare
firstnum := 1;
lastnum := 10;
c_return is ref cursor;
begin
test.test_rows(firstnum,lastnum,c_return);
dbms_output.put_line('Result: '||c_return);
end;
/
Basically, I need a test script to get the result of a cursor.
This thing is returning a subset of records, like the first 10 records, the first 15, or whatever.
Thanks.