-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|