Page 1 of 1

DBMS_OUTPUT Problem

Posted: Fri 21 Dec 2007 22:37
by dim
Hi,

If I use DBMS_OUTPUT.putline to print some debug message, nothing appears in the output window.

I tried to use DBMS_OUTPUT.enable. It does not help.

But if I use 'set serveroutput on' in sql plus, sql plus will be able to print debug messages. DBMS_OUTPUT.enable does not help in sql plus either.

But OraDeveloper does not support 'set' command.

If this is something I should ask for my Oracle DBA, what should I ask for?

Thanks and have a nice Christmas.

Posted: Sat 22 Dec 2007 07:07
by Duke
The correct way to work with DBMS_OUTPUT in our product is to enable it via Database Connection Dialog Box (Advanced tab).
Did you try this way?

Posted: Wed 26 Dec 2007 15:48
by dim
It worked. Thanks.