trying to test a procedure with a cursor, help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: trying to test a procedure with a cursor, help

Hybrid View

  1. #1
    Join Date
    May 2004
    Location
    Central FL
    Posts
    12

    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.

  2. #2
    Join Date
    May 2004
    Location
    Central FL
    Posts
    12
    Okay, hey, I'm testing this in our application with a Java call now, so I don't need help anymore.

    Thanks anyway.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width