Re: program too large error

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/03/31
Message-ID: <954530279.21334.0.pluto.d4ee154e@news.demon.nl>#1/1

Break your procedure into parts, I really can't help it. There's a limit of 64k.
Check in user_objects how large your procedure is to verify.

Hth,

Sybrand Bakker, Oracle DBA

anurag <aminochaNOamSPAM_at_unibiz.com.invalid> wrote in message news:02db9848.8d958388_at_usw-ex0104-033.remarq.com...
> Hi,
> when I try to compile a stored procedure it gives a program too
> large error.
> I tried increasing the log buffer and other parameters in the
> init parameter file but still no help.
>
> What should i do to prevent this error . I do not want to break
> my procedure into parts.
>
> Thanks
> Anurag
>
> also reply at
> aminocha_at_unibiz.com
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Fri Mar 31 2000 - 00:00:00 CST