DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Dbms_output

  1. #1
    Join Date
    Aug 2004
    Location
    new jersey
    Posts
    6

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    is serveroutput set to on?

  3. #3
    Join Date
    Feb 2005
    Posts
    158
    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
  •  


Click Here to Expand Forum to Full Width