I have a PSQL (not in a procedure) that uses dbms_output.put_line.But the output exeeds 1.000.000 chars (that is the maximum buffer size).
So I need to change the way of output the results.
I looked arround on the internet, but the solution to write to an other table is not possible (because I use a read-only database and I have no rights to change this).
Can someone advise me here what I can do.
(Small remark : I am not an expert in PL/SQl and ORACLE)