DBMS_OUTPUT.PUT_LINE not printing anything

plsql oracle10g sqlplus dbms-output
osimer pothe picture osimer pothe · Nov 28, 2015 · Viewed 21.2k times · Source

When executing the following code, it just says the procedure is completed and doesn't print the infomation . 

BEGIN
 dbms_output.put_line('This is my first program');
END;
/

When I execute the above code the compiler says , PL/SQL procedure successfully completed but doesn't print anything to the console . What can I do ?

Answer

osimer pothe picture osimer pothe · Nov 28, 2015

Switch the serveroutput on by 

Set serveroutput on

Related questions

DBMS_OUTPUT.PUT_LINE not printing

When executing the following code, it just says the procedure is completed and doesn't print the infomation i want it to (firstName, lastName) and then the other values from the select query in a table below. CREATE OR REPLACE PROCEDURE …

Read More
dbms_output size buffer overflow

I tried to set the dbms_output size to unlimited inside a stored procedure. But it gave me compilation errors. So I tried in the SQL*Plus prompt the below way. But still I get the buffer overflow error. How …

Read More
Ugly formatting in SQL*Plus

It is really annoying that when I run a select command in SQL*Plus such as: SELECT * FROM books; The output is really badly formatted and unreadable (row cells are not in a row but separated by line breaks etc): …

Read More