3 years ago

Category: Database, Data

DBMS_OUTPUT package in Oracle, like other DBMS packages, is owned by the Oracle user SYS. The script which creates DBMS_OUTPUT grants the EXECUTE permission on the package to the PUBLIC, and creates a public synonym for it.

The syntax for the PUT and PUT_LINE calls are: Where a is the argument to be placed in the buffer.

For example: The syntax for the ENABLE and DISABLE calls is: Where buffer_size is the initial size of the internal buffer, in bytes.

If DISABLE is called, the contents of the buffer are purged, and subsequent calls to PUT and PUT_LINE do not affect.