DBMS_OUTPUT not showing lines when procedure executes OK [message #672184] |
Fri, 05 October 2018 13:34 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/14d243a966f31c76a2970340b894eca8?s=64&d=mm&r=g) |
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
|
|
|
|
|
|
|
|
|
|