Home » RDBMS Server » Server Administration » Error
Error [message #205279] Fri, 24 November 2006 02:49 Go to next message
deni_sa
Messages: 77
Registered: June 2006
Member
When I use the update procedure that you suggested below at some point in time I get this error message and the update is not done:

BEGIN update_site; END;



*

ERROR at line 1:

ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes

ORA-06512: at "SYS.DBMS_OUTPUT", line 35

ORA-06512: at "SYS.DBMS_OUTPUT", line 198

ORA-06512: at "SYS.DBMS_OUTPUT", line 139

ORA-06512: at "XSITELIVE.UPDATE_SITE", line 12

ORA-06512: at line 1



Can you help?
Re: Error [message #205295 is a reply to message #205279] Fri, 24 November 2006 03:22 Go to previous messageGo to next message
bwetkstr
Messages: 114
Registered: August 2005
Senior Member
Hi,


SET SERVEROUTPUT ON SIZE 100000

Kr
Karel.
Re: Error [message #205317 is a reply to message #205279] Fri, 24 November 2006 04:31 Go to previous messageGo to next message
deni_sa
Messages: 77
Registered: June 2006
Member
thank you , i made the change that u suggested, now i don't get the error message ,but stil the update is not done .

Don't know what to do:-(((
Re: Error [message #205318 is a reply to message #205317] Fri, 24 November 2006 04:38 Go to previous messageGo to next message
bwetkstr
Messages: 114
Registered: August 2005
Senior Member
deni_sa wrote on Fri, 24 November 2006 11:31
thank you , i made the change that u suggested, now i don't get the error message ,but stil the update is not done .

Don't know what to do:-(((


Post script you're trying to run + errors you are recieving

Kr
Karel
Re: Error [message #205322 is a reply to message #205279] Fri, 24 November 2006 04:44 Go to previous messageGo to next message
deni_sa
Messages: 77
Registered: June 2006
Member
No error mesage now it just doesn't do the update
Re: Error [message #205328 is a reply to message #205279] Fri, 24 November 2006 04:52 Go to previous messageGo to next message
bwetkstr
Messages: 114
Registered: August 2005
Senior Member
Not enough information to help
Re: Error [message #205329 is a reply to message #205328] Fri, 24 November 2006 04:53 Go to previous messageGo to next message
deni_sa
Messages: 77
Registered: June 2006
Member
Thank you anyway
Re: Error [message #205349 is a reply to message #205329] Fri, 24 November 2006 05:37 Go to previous message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If this procedure's job is to UPDATE a table, why do you need DBMS_OUTPUT.PUT_LINE in it? Kick that out and run the procedure again. Or, if you really are interested in output, use UTL_FILE instead.
Previous Topic: ORA-01669: standby database control file not consistent
Next Topic: how to advice manager to chose the oracle or sqlserver
Goto Forum:
  


Current Time: Thu Dec 08 05:53:18 CST 2016

Total time taken to generate the page: 0.11773 seconds