Avatar of haezeban

asked on 

SQL-Developer : PL/SQL dbms_output.put_line buffersize 1000000 exceeded - how to do it now?

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)

Oracle Database

Avatar of undefined
Last Comment

8/22/2022 - Mon