|
ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes 2 Years, 6 Months ago
|
Karma: 0
|
|
Hi, I am using lots of dbms_output.put_line() statements in my stored procedure for debugging and my stored procedure has to process some where 1000 rows... and each row has arond 100 columns.
I am able to process 5-6 rows but after that my procedure throws ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes
Any idea how to fix it?
|
|
dnegi
Fresh Boarder
Posts: 17
|
|
|
|
|
Re:ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes 2 Years, 6 Months ago
|
Karma: 0
|
|
Can I know which oracle version you are using?
You can try to put DBMS_OUTPUT.ENABLE(null); at start of your stored procedure... I think this should solve your buffer overflow problem.
Please let me know if it doesn't work for you...
|
|
rpawar
Fresh Boarder
Posts: 12
|
|
|
|
|
Re:ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes 2 Years, 6 Months ago
|
Karma: 0
|
|
Thank You, It worked for me..
|
|
dnegi
Fresh Boarder
Posts: 17
|
|
|
|
|
Forum
