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.