DBMS_OUTPUT.PUT_LINE_UDF

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Definition

This user-defined function (UDF) is used to replicate the functionality of the Oracle DBMS_OUTPUT_PUT_LINE function.

DBMS_OUTPUT.PUT_LINE_UDF(LOG VARCHAR)

Notice that performance may be affected by using this UDF. To start logging information uncomment the implementation inside the function.

Parameters

LOG VARCHAR

The information to be shown in the command line.

Returns

Returns a varchar with the information logged.

Usage example

Input:

SELECT DBMS_OUTPUT.PUT_LINE_UDF(to_varchar(123));

Output:

123