Hello All,
In Oracle 12c, is there a way to print clob variable as is? I mean, I want to print the clob variable completely as it is.
I know the following link but we don't use APEX. So, what do you recommend?
Split CLOB into lines | Jeff Kemp on Oracle (0 Bytes)
Also the following code is not print clob variable as is, it can divide it.
CREATE OR REPLACE PROCEDURE print_clob_to_output (p_clob IN CLOB)
IS
l_offset INT := 1;
BEGIN
dbms_output.put_line('Print CLOB');
loop
exit when l_offset > dbms_lob.getlength(p_clob);
dbms_output.put_line( dbms_lob.substr( p_clob, 255, l_offset ) );
l_offset := l_offset + 255;
end loop;
END print_clob_to_output;
Oracle Live SQL - Script: print_clob_to_output (0 Bytes)
Thanks