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 next 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

Re: DBMS_OUTPUT not showing lines when procedure executes OK [message #672185 is a reply to message #672184] Fri, 05 October 2018 13:43 Go to previous messageGo to next message
BlackSwan
Messages: 26643
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Usually it is not possible to debug code that can NOT be seen.

Do you have error of commission (did something wrong)?
Do you have error of omission (did NOT do something that needs to be donw)?
Re: DBMS_OUTPUT not showing lines when procedure executes OK [message #672186 is a reply to message #672184] Fri, 05 October 2018 14:17 Go to previous messageGo to next message
Michel Cadot
Messages: 66728
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Welcome to the forum.
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Also always post your Oracle version, with 4 decimals, as solution depends on it.

Use SQL*Plus and copy and paste your session, the WHOLE session.

Re: DBMS_OUTPUT not showing lines when procedure executes OK [message #672188 is a reply to message #672184] Fri, 05 October 2018 15:36 Go to previous messageGo to next message
EdStevens
Messages: 1148
Registered: September 2013
Senior Member
Can you debug code that you cannot see? No? Well, neither can anyone else.
Re: DBMS_OUTPUT not showing lines when procedure executes OK [message #672272 is a reply to message #672184] Tue, 09 October 2018 13:23 Go to previous messageGo to next message
thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC
Member

It's working here - problem is probably in your mystery plsql code

https://www.thatjeffsmith.com/wp-content/uploads/2018/10/dbms-orafaq.png
Re: DBMS_OUTPUT not showing lines when procedure executes OK [message #672276 is a reply to message #672272] Tue, 09 October 2018 16:43 Go to previous messageGo to next message
BlackSwan
Messages: 26643
Registered: January 2009
Location: SoCal
Senior Member
OP seems to be a write once & return never user.
Re: DBMS_OUTPUT not showing lines when procedure executes OK [message #672277 is a reply to message #672276] Tue, 09 October 2018 17:20 Go to previous messageGo to next message
marineboyed
Messages: 2
Registered: October 2018
Junior Member
I'm sorry.
I cannot post the whole package code as it has more than 2.000 lines.
That's why I made a skeleton of the code.
Thanks to all of you who reponded.
Re: DBMS_OUTPUT not showing lines when procedure executes OK [message #672282 is a reply to message #672277] Wed, 10 October 2018 02:44 Go to previous message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
You still need to give some kind of example.
Previous Topic: user had different system date extracted compared with oracle
Next Topic: SQL*Plus output problem (merged 3)
Goto Forum:
  


Current Time: Sat Dec 14 18:06:12 CST 2019