-
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
-
David Knight
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,
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?
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
|