Home » SQL & PL/SQL » Client Tools » DBMS_OUTPUT not showing lines when procedure executes OK
DBMS_OUTPUT not showing lines when procedure executes OK [message #672184] Fri, 05 October 2018 13:34 Go to previous message
marineboyed
Messages: 2
Registered: October 2018
Junior Member
Hi,

I'm running a procedure via SQL Developer:
SET SERVEROUTPUT ON

DECLARE

  variables

  CALL to the procedure with in and out variables

  DBMS_output.put_line() for each output variable.
The thing is:
IF procedure returns with an error code (controlled by the code), all my put_line s are printed after the message "anonymous block completed".

However, if everything is fine with the execution of the procedure, I still want to see the output variables, and I just got the message "anonymous block completed" but nothing more.

Is there something missing?

Thanks a lot.

[EDITED by LF: applied [code] tags]

[Updated on: Sat, 06 October 2018 01:48] by Moderator

Report message to a moderator

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: user had different system date extracted compared with oracle
Next Topic: SQL*Plus output problem (merged 3)
Goto Forum:
  


Current Time: Mon Jan 20 17:34:19 CST 2020