AskToad.com -- Home of your Toad Oracle KnowledgeBase

DBMS_Output

Does DBMS Output display while the PL/SQL executes?

No. The DBMS buffer is not released by Oracle until the PL/SQL block completes. If you are not seeing the DBMS Output after the block executes, make sure that before you run the block, you toggle DBMS Output on via the DBMS Output tab in the SQL Editor, or that you go to Options → SQL Editor and turn on "Automatically poll for DBMS Output"



Personal tools

11/30/09