Search notes:

Oracle: DBMS_OUTPUT

Send messages from stored procedures (poor man's debugging)

Procedures

`disable`
`enable`
`get_line`
`get_lines`
`get_lines`
`new_line`
`put`
`put_line`

See also

dbms_pipe allows to send messages between two or more sessions.

Oracle DBMS PL/SQL packages

Turning on dbms_output in SQL Developer.

See also the menu View -> Dbms Output.

$ORACLE_HOME/rdbms/admin/dbmsotpt.sql

In order to automatically enable dbms_output in SQL Developer, the value of Filename for connection startup script, found under the menu Tools -> Preferences -> Databases might be set to a script that contains set serveroutput on.

outon.sql is a most simple SQL script to be put into a $SQLPATH directory. It «enables» dbms_output in SQL*Plus.