Home Oracle Commands Oracle Packages
PL/SQL Books

PL/SQL Packages DBMS_OUTPUT

Send messages between stored procedures, packages, and triggers.
This package is especially useful for displaying PL/SQL debugging information.

Subprocedures:

ENABLE   Enables message output. 

DISABLE  Disables message output. 

PUT      Places a line in the buffer.

PUT_LINE Places partial line in buffer. 

NEW_LINE Terminates a line created with PUT. 

GET_LINE Retrieve one line from the buffer.

GET_LINES Retrieve an array of lines from buffer.  

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al
Related Commands:

Related Packages:




Back to the Top

Simon Sheppard
SS64.com