invantive documentation
Invantive Support ForumsLog In / Sign Up

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-notices is on, which it is by default.
  • IBM DB2 and Teradata, available from release 27.0.97.