dbms_output.put_line

[Scott Paul]

Howdy!

I can never get dbms_output.put_line() to display any information in the Test Window DBMS Output tab. I know it must be some sort of configuration problem, but I don't know how to solve it. I have my preferences -> Output "Enabled", and when I press the DBMS Output tab it shows "Enabled". But when I run through the code in the Test Window, I never see the output. Is there something else I need to configure?

 

[Marco Kalter]

There is no other configuration involved. Note that the output will only be displayed after the script has run to completion (i.e. not during while debug session is running).

One other possibility is that your application disables or reads the dbms_output. A simple "begin dbms_output.put_line('Hello'); end;" test script would verify this.

 

[Scott Paul]

Ah, thanks. I was under the impression that the output lines would be displayed interactively.