dbms_output not working in procedure
claghornMay 13 2011 — edited May 13 2011Here is my procedure:
create or replace
PROCEDURE TD_TEST1 AS
begin
dbms_output.enable;
dbms_output.put_line('Hello oracle!');
exception
when others then
null;
END TD_TEST1;
It outputs the following when I run the procedure using the "play" button in SQL Developer.
Connecting to the database...
Hello oracle!
Process exited.
Disconnecting from the database...
But when I run the following code from another sql worksheet connected to the same db here what happens:
BEGIN
TD_TEST1();
END;
anonymous block completed
Why no Hello oracle! ?
SQL Plus does it!