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
OCP DBA 8i, 9i, 10g
I can not see using server output on. it's a multiple data
set serveroutput on on SQL prompt,
In PL/SQL Code, use package,
To see the output, U can use the function,
DBMS_OUTPUT.putline(' Your Message '||VariableName);
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
Can you print your program?
Click Here to Expand Forum to Full Width