OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » interesting error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

interesting error [message #57807]

Tue, 08 July 2003 13:00

sidd
Messages: 130
Registered: May 2003

Senior Member

ERROR at line 1:
ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 91
ORA-06512: at "SYS.DBMS_OUTPUT", line 58
ORA-06512: at line 27

Report message to a moderator

Re: interesting error [message #57813 is a reply to message #57807]

Tue, 08 July 2003 18:03

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

execute this,
before running the plsql
or call it  inside plsql block

exec dbms_output.enable('100000');
-- or any higher value

Report message to a moderator

Re: interesting error [message #57815 is a reply to message #57813]

Tue, 08 July 2003 18:59

sidd
Messages: 130
Registered: May 2003

Senior Member

i used set command to resolve the issue.. but
is there any alternative way of printing without using dbms_output.put_line ?

Report message to a moderator

Re: interesting error [message #57821 is a reply to message #57815]

Wed, 09 July 2003 05:58

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

u mean, 
displaying to the console ( screen) from pl/sql?
dbms_output is the best and easiest.
dbms_output is supposed to be used for debugging in development stage
ideally, no end user is going to use sqlplus as their tool!

Report message to a moderator

Previous Topic:	Before update trigger ??
Next Topic:	How can I take a source of pakage from oracke

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 13:34:31 CDT 2024