-
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
-
-
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,
DBMS_OUTPUT
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
-
Hi,
Can you print your program?