DBMS_OUTPUT not showing lines when procedure executes OK [message #672184] |
Fri, 05 October 2018 13:34 |
|
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
|
|
|
|
|
|
|
|
|
|