Topic
  • 6 replies
  • Latest Post - ‏2019-05-14T04:50:59Z by MarieG
davidliu
davidliu
4 Posts

Pinned topic PL/SQL DBMS_OUTPUT.PUT_LINE

‏2011-07-07T22:29:43Z |
Where/How could I see the PL/SQL DBMS_PUTPUT.PUT_LINE output in IBM Data studio?
For example:
CREATE OR REPLACE PROCEDURE simple_procedure
IS
BEGIN
DBMS_OUTPUT.PUT_LINE('That''s all folks!');
END simple_procedure;

Thanks.
Updated on 2011-07-12T17:06:05Z at 2011-07-12T17:06:05Z by lakshman
  • lakshman
    lakshman
    67 Posts

    Re: PL/SQL DBMS_OUTPUT.PUT_LINE

    ‏2011-07-08T04:32:15Z  
    Its a good question... We are checking with DB2 team where does it stores the OUTPUT information and we will get back to you soon

    IBM Team
  • davidliu
    davidliu
    4 Posts

    Re: PL/SQL DBMS_OUTPUT.PUT_LINE

    ‏2011-07-08T16:43:53Z  
    • lakshman
    • ‏2011-07-08T04:32:15Z
    Its a good question... We are checking with DB2 team where does it stores the OUTPUT information and we will get back to you soon

    IBM Team
    Thanks, looking forward to hearing from you.
  • lakshman
    lakshman
    67 Posts

    Re: PL/SQL DBMS_OUTPUT.PUT_LINE

    ‏2011-07-12T17:06:05Z  
    • davidliu
    • ‏2011-07-08T16:43:53Z
    Thanks, looking forward to hearing from you.
    Hi David,

    We apologize for little late reply.

    You need to set statement "SET SERVEROUTPUT ON" to see the output of the DBMS package, please refer the document for further details by using following link.
    http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp

    Unfortunately this SET command is not working in DataStudio. We are investigating this issue and address this problem in next release. If this is very important for you and need a immediate fix, please contact IBM support.
    Thanks
    IBM Team
  • Mon_UCPB
    Mon_UCPB
    1 Post

    Re: PL/SQL DBMS_OUTPUT.PUT_LINE

    ‏2016-12-23T02:31:40Z  
    • lakshman
    • ‏2011-07-12T17:06:05Z
    Hi David,

    We apologize for little late reply.

    You need to set statement "SET SERVEROUTPUT ON" to see the output of the DBMS package, please refer the document for further details by using following link.
    http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp

    Unfortunately this SET command is not working in DataStudio. We are investigating this issue and address this problem in next release. If this is very important for you and need a immediate fix, please contact IBM support.
    Thanks
    IBM Team

    Was this ever resolved? I am trying to use the same functionality in data studio 4.1.1 and this functionality still seems not to work. 

  • BenMathews
    BenMathews
    1 Post

    Re: PL/SQL DBMS_OUTPUT.PUT_LINE

    ‏2017-01-04T19:30:19Z  
    • Mon_UCPB
    • ‏2016-12-23T02:31:40Z

    Was this ever resolved? I am trying to use the same functionality in data studio 4.1.1 and this functionality still seems not to work. 

    I would also like to see this resolved.

     

    Using Data Studio 4.1.0.0.

     

    Docs for SET SERVEROUTPUT mentions that setting it to ON calls DBMS_OUTPUT.ENABLE() which returns successful in Data Studio; but I have no idea which view to use to see the output. It does not appear in console view.

    Updated on 2017-01-04T19:31:21Z at 2017-01-04T19:31:21Z by BenMathews
  • MarieG
    MarieG
    2 Posts

    Re: PL/SQL DBMS_OUTPUT.PUT_LINE

    ‏2019-05-14T04:50:59Z  

    I would also like to see this resolved.

     

    Using Data Studio 4.1.0.0.

     

    Docs for SET SERVEROUTPUT mentions that setting it to ON calls DBMS_OUTPUT.ENABLE() which returns successful in Data Studio; but I have no idea which view to use to see the output. It does not appear in console view.

    2 years later, and still seems to be a problem in DS 4.1.3. The skeleton script below runs fine, but i don't see any way to see the output. I've tried toggling tabbed view, and displaying all results in a single tab, and displaying resuits in text mode - nothing. 

     

    BTW - this thread did let me know to use the call to dbms_output.enable() vs set serveroutput on.

     
    begin
        declare counter int default 0;
            set counter = counter + 1;
            call dbms_output.enable();
            call dbms_output.put_line ('Counter:'||counter);
    end

    Updated on 2019-05-14T04:52:03Z at 2019-05-14T04:52:03Z by MarieG