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