How to see result set form pl/sql block
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: How to see result set form pl/sql block

  1. #1
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    I am trying to run pl/sql using ref cursor as out parameter (for result set) result set back.
    I do not know How to see my result set using pl/sql block.
    Does any body has any idea ?
    Also can any body tell me how can I use %rowcount for check number of rows in result stat. It's select statment






  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    Try

    set serveroutput on;
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    I can not see using server output on. it's a multiple data

  4. #4
    Join Date
    Nov 2000
    Posts
    224
    set serveroutput on on SQL prompt,

    In PL/SQL Code, use package,

    DBMS_OUTPUT

    To see the output, U can use the function,

    DBMS_OUTPUT.putline(' Your Message '||VariableName);

  5. #5
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    It is a multi raw result set. can not be stored in a variable. it is selected using opening ref cursor.
    It can not been seen through dbms_output


  6. #6
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Hi,

    Can you print your program?

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