Buffer overflow [message #36935] |
Fri, 04 January 2002 20:43 |
sudhir
Messages: 20 Registered: November 2000
|
Junior Member |
|
|
dear all
i am facing a problem
when i complile procedure or trigger i get a error
that bufferoverflow use set option to reduce the arraysize and increase the maxdata
i m not able to solve this
plz tell me that how can i overcome this problem
regards s
sudhir
|
|
|
Re: Buffer overflow [message #36936 is a reply to message #36935] |
Fri, 04 January 2002 21:05 |
Somu
Messages: 24 Registered: February 2000
|
Junior Member |
|
|
Hi,
use the following to solve the problem.
set arraysize 1
after the above command compile the procedure
|
|
|
Re: Buffer overflow [message #36942 is a reply to message #36935] |
Sun, 06 January 2002 16:01 |
diaz
Messages: 58 Registered: October 2001
|
Member |
|
|
hello,
i'm having the same problem after running my code, and i have tried your given solution.. still doesn't work..
the error is :
ERROR at line 1:
ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 106
ORA-06512: at "SYS.DBMS_OUTPUT", line 65
ORA-06512: at line 28
can somebody help me on this ..
please..
thanks
|
|
|
Re: Buffer overflow [message #36959 is a reply to message #36942] |
Mon, 07 January 2002 10:36 |
raghav banuru
Messages: 6 Registered: January 2002
|
Junior Member |
|
|
If you are calling procedure and setting the serveroutput on then increase this line limit it will slove your prob.
dbms_output.enable(1000000);
All the Best.
|
|
|
|
Re: Buffer overflow [message #38832 is a reply to message #36942] |
Sun, 19 May 2002 13:13 |
Weifen
Messages: 1 Registered: May 2002
|
Junior Member |
|
|
I do not know whether you use a cursor or some loops. It enters an endless one.
You should add command like Exit When C1%NOTFOUND to end it.
|
|
|
|