dbms_output.put_line prints nothing in SQL Developer version 18.1.0.095

oracle-sqldeveloper dbms-output
Stack0verflow picture Stack0verflow · Jul 10, 2018 · Viewed 8.1k times · Source

My database is:

Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit

The company just gave me a new desktop with Windows 10. I installed SQL Developer version 18.1.0.095 Build 095.1630. Everything works fine except that dbms_output.put_line no longer prints anything. For example this simple script:

SET SERVEROUTPUT ON;
BEGIN
  dbms_output.put_line('hola');  
END;

simply gives me this:

enter image description here

Whereas on a Windows 7 Professional box, with SQL Developer version 4.2.0.17.089 Build 17.089.1709 connected to the same oracle instance, the exact same script does print out hola nicely. Look:

enter image description here

Also, Toad version 12.12.0.39 executes this script and prints out hola without an issue.

I see that one guy has the same problem with the same version of SQL Developer at here: https://www.thatjeffsmith.com/archive/2012/03/dbms_output-in-sql-developer/ Check the comment section.

Could this be a bug with version 18.1.0.095?

Answer

Nizar Alahmadi picture Nizar Alahmadi · Dec 23, 2020

try the following

SET SERVEROUTPUT ON; BEGIN...

Related questions

How to redirect the output of DBMS_OUTPUT.PUT_LINE to a file?

I need to debug in pl/sql to figure times of procedures, I want to use: SELECT systimestamp FROM dual INTO time_db; DBMS_OUTPUT.PUT_LINE('time before procedure ' || time_db); but I don't understand where the output …

Read More
Rudimentary issue: basic PL/SQL console output?

I am using SQL Developer and want to output the contents of a variable to the console using DBMS_OUTPUT.PUT_LINE(). I am running the following code that adds the numbers 1 through 5 inclusive but I'm not seeing any output. …

Read More
sqldeveloper - DBMS_OUTPUT.PUT_LINE() Doesn't Work

I am trying to print the value passed to the DBMS_OUTPUT.PUT_LINE() function to the DBMS_OUTPUT screen in SQL Developer. No matter what I pass to the function, nothing gets printed in the output window. I have …

Read More