dbms_output
The dbms_output package provides functions to send text to an output channel.
put: Print text
Output the text supplied as parameter. An optional second parameter is the text label of the channel.
Parameters:
txt(string, optional): Text to print.channel(string, optional): Label of the channel.
put_line: Print line of text
Output the text supplied as parameter and add a linefeed. An optional second parameter is the text label of the channel.
Parameters:
txt(string, optional): Text to print.channel(string, optional): Label of the channel.
Messages of the Database Server
Messages which a database server sends next to the result of a statement are added to the output, such as a warning, an informational message, a PostgreSQL notice raised with raise notice or a line of the Oracle dbms_output package. This includes the statements of execute native. Each message is preceded by a line which names the data container.
The drivers which pass these messages on are:
- Firebird, MySQL, ODBC, Oracle and SQL Server.
- PostgreSQL, when the provider attribute
npgsql-noticesis on, which it is by default. - IBM DB2 and Teradata, available from release 27.0.97.