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?
is serveroutput set to on?
this space intentionally left blank
How are you calling the function, and what is the client.
Using sqlplus 220.127.116.11, 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.
Click Here to Expand Forum to Full Width