PUT_LINE procedure
Translation reference for DBMS_OUTPUT.PUT_LINE.
Last updated
Translation reference for DBMS_OUTPUT.PUT_LINE.
Last updated
This procedure places a line in the buffer. ()
This UDF is implemented using a temporary table to insert the data to be displayed to replicate the functionality of Oracle DBMS_OUTPUT.PUT_LINE
function.
The DBMS_OUTPUT
schema must be created.
LOG: Item in a buffer that you want to display.
If you do not use the temporary table, keep in mind that you may need another column in the table where the USER running DBMS_OUTPUT.PUT_LINE UDF is inserted to avoid confusion.
Oracle
The UDF code will remain commented out because it can affect performance, if the user decides to use it, they just need to uncomment the code.
The user can modify the UDF so that the necessary information is inserted into the DBMS_OUTPUT.PUT_LINE table.
SSC-FDM-OR0035: Check UDF implementation for DBMS_OUTPUT.PUT_LINE_UDF.
The store non-permanent transitory data. They only exist within the session in which they were created and persist only for the rest of the session. After the session ends, the data stored in the table is completely removed from the system and is therefore not recoverable, either by the user who created the table or by Snowflake.