DBMS_OUTPUT.PUT_LINE_UDF

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