Disabling DBMS_OUTPUT

[Peter Zolja]

Perhaps I don't understand correctly how dbms_output.disable works, but if I disable it (TOracleSession.DBMS_Output.Disable), it still works; meaning that I can access the output (DBMS_Output.Get_Lines).

If all I run is a PL/SQL block and I call "disable" from the same block it works, but subsequent blocks (where I don't call "disable") do get the output.

I guess my question is: How can disable the output at a session level? Some functions can use put_line and if the buffer is not big enough nothing is returned, so in some cases it would be useful to be able to completely disable the output.

Thank you.

 

[Marco Kalter]

The Disable function works at the session level. If it is enabled again later, then I can only assume that the Enable procedure was called in between.

 

[Peter Zolja]

Ahhh, how stupid of me! Found it hidden somewhere in my code. Thank you!