Wednesday, August 15, 2012

PL-SQL logging info with DBMS_OUTPUT.PUT_LINE in SQL Developer

unless you explicitly enable the logging, you will never see anything...

SET SERVEROUTPUT ON;

BEGIN

  DBMS_OUTPUT.ENABLE;
 DBMS_OUTPUT.PUT_LINE('Hello...');

 DBMS_OUTPUT.PUT_LINE('Goodbye.');
 END;
 /



in a stored procedure, just do

dbms_output.enable (1000000);

No comments:

Post a Comment

comments where you are promoting your business will be marked as SPAM :o)