---
title: "dbms_output"
description: "The dbms_output package provides functions to send text to an output channel."
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/docs/invantive-universalsql/packages/dbms-output
original: https://documentation.invantive.eu/en/docs/invantive-universalsql/packages/dbms-output
updated: 2026-11-11T00:00:00Z
license: https://documentation.invantive.eu/en/
---

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.