-3

DBMS_OUTPUT.PUT_LINE( ) doesn't print output however output and spooling are turned on. "Procedure is completed successfully" message is displayed without any output. When run in SQLPLUS it throws errors.

Do you have any idea to check? I tried the DBMS_OUTPUT.ENABLE() etc.

Gary_W
  • 9,933
  • 1
  • 22
  • 40
Willy
  • 45
  • 1
  • 8
  • 1
    While I agree that a neg vote should be accompanied by an explanation otherwise it doesn't teach anyone anything, calling names and using profanity are just going to get your question closed and you booted. A bad way for a new user to get started here. Instead, consider reviewing your question. Don't type in all caps and make sure all relevant info is present. What version of Toad are you using? Against what database/version? Maybe reword to make the question clearer? What errors did sqlplus throw? Ask in the comments what further info is needed to clarify. Good luck. – Gary_W Feb 19 '16 at 21:51

2 Answers2

1

Make sure you "execute as a script" by pressing F5. Make sure the editor window has this line before calling your procedure:

set serveroutput on size unlimited;

Here is an example calling a homegrown function that returns an element from a list (in this case the 6th element, "mirror") where the delimiter is a space. Note you can view output on the "DBMS Output" tab too (click the "turn output on" button first).

Click on the image to view full size Click on the image to view full size

Gary_W
  • 9,933
  • 1
  • 22
  • 40
0

i found this little tricky button in jetBrains Datagrip, it turns on dbms_output without any dbms_output.enable or set serveron etc.

enter image description here

Alexey Nikonov
  • 4,958
  • 5
  • 39
  • 66