| Error [message #205279] |
Fri, 24 November 2006 02:49  |
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 #205317 is a reply to message #205279] |
Fri, 24 November 2006 04:31  |
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 |
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 #205349 is a reply to message #205329] |
Fri, 24 November 2006 05:37 |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
