-
Dbms_output
I am using DBMS_OUTPUT. PUT_LINE from a function and it is not displaying the results. Similar stmt from procedure works fine. When I execute DBMS_OUTPUT.enable then it displays. Is there a limitation that DBMS_OUTPUT does not work from functions?
Thanks
-
is serveroutput set to on?
-
How are you calling the function, and what is the client.
Using sqlplus 9.2.0.1, if I do a SELECT func FROM DUAL;
it doesdn't show the dbms_output immediately after the select. It shows it if I later do a exec DBMS_OUTPUT.put_line
However in sqlplus 10.2.0.1, it shows the dbms_output straight afer the select.
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
|