PL SQL output is not getting displayed

Question

I have fairly simply code ..running in Oracle Virtualbox. However for some reason it is not displaying pl/sql output.

Here is code snippet

SQL> set serveroutput on
SQL> list
    1   Create or Replace procedure mytz
    2       IS
    3       v_mytz TIMESTAMP WITH TIME ZONE DEFAULT '2013-05-05 12:00:00 AM';
    4       BEGIN
    5       DBMS_OUTPUT.PUT_LINE ('Default timestamp is ' );
    6*     end mytz ;
SQL> /

     Procedure created.

 SQL>

Is there anything I need to do special to see the output on SQL prompt ?

Alex Poole · Accepted Answer · 2013-05-05 23:53:37Z

1

You have to actually run the procedure, not just create it, e.g.:

set serverputput on
exec mytz;

The set serveroutput SQL*Plus command has to be in the session the procedure is executed, not the one where it is created (if they are different).

You are not showing the value of your variable at the moment; maybe you wanted this?

    dbms_output.put_line('Default timestamp is: ' || v_mytz);

answered May 5, 2013 at 23:53

Alex Poole

192k11 gold badges198 silver badges349 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Vishal Over a year ago

Thank you. That was it. ps: I had purposely had not added v_mytz. Now I am getting output from this and other procs also.

Alex Poole Over a year ago

@Vishal - I should also have pointed out that you're using implicit format models for your conversions. You should be using to_timestamp for the assignment and to_char for display, using explicit format models; otherwise it will behave differently and might error in sessions with different NLS settings.

Collectives™ on Stack Overflow

PL SQL output is not getting displayed

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related