Home » SQL & PL/SQL » SQL & PL/SQL » buffer overflow
buffer overflow [message #357888] Fri, 07 November 2008 01:00 Go to next message
deepshikhahcl
Messages: 14
Registered: October 2008
Junior Member
hi ,

I am executing one procedure and I have included dbms_output statement to print the output.As the output prints a very long query thats why i am getting the follwing error :

ORA-20000: ORU-10028: line length overflow, limit of 255 chars per line

I have set the serveroutput to maximum.
I am spooling the ouput to a file but still the problem presist.
Can anyone help.

Deepshikha
Re: buffer overflow [message #357893 is a reply to message #357888] Fri, 07 November 2008 01:14 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Cut the lines to 255-characters chunks and feed those to dbms_output.put_line
Re: buffer overflow [message #357894 is a reply to message #357888] Fri, 07 November 2008 01:14 Go to previous message
Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Each line cna't exceed 255 characters in your version (that you didn't specify as you should).
The only workaround is to split the lines.

Regards
Michel
Previous Topic: LOBSEGMENT
Next Topic: pls help
Goto Forum:
  


Current Time: Tue Apr 23 06:00:49 CDT 2024