troubleshooting Question

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

Avatar of haezeban
haezeban asked on
Oracle Database
7 Comments1 Solution9368 ViewsLast Modified:
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)

Muhammad Noman Iqbal

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros