Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: 2 problems in using package........
To solve the first problem execute
exec dbms_output.enable(100000);
before your procedure, where 100000 is the new size of the buffer in bytes.
Marek M.
>
> Jimmy wrote:
>
> > Hello all,
> > I have 2 problems about using package.
> >
> > Then after somtime, following message show:
> > ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
> > ORA-06512: at "SYS.DBMS_OUTPUT", line 100
> > ORA-06512: at "SYS.DBMS_OUTPUT", line 59
> > ORA-06512: at "USER.UPDATE_CCC", line 64
> >
> > 1) Could anyone tells me why such message show and how to solve
this
> > problem?
> >
Received on Thu Aug 27 1998 - 00:00:00 CDT
![]() |
![]() |