Re: Procedure too big?

From: Bill Cohagan <bill_at_XNOSPAMXteraquest.com>
Date: Tue, 14 Dec 1999 00:21:23 -0600
Message-ID: <zsl54.87$zy.18482@newsin1.ispchannel.com>

Conner-
Thanks for the response. Guess I'll dig in to the code to find the real problem. BTW, is there a good place to find quantitative info like this in the Oracle docs? The web based docs that came with PE have some info, but hopefully there's a more complete set somewhere.

Thanks again,
Bill

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:3854CEA2.4637_at_yahoo.com...
> Bill Cohagan wrote:
> >
> > [Using Oracle 8.0.4 PE]
> >
> > What is the maximum number of characters allowed in the text defining a
> > stored procedure? I've got some large procedures that won't compile and
I
<snip>....

> It used to be about 64k but I think that limit has been increased in 8.0
> or 8.1...Now I think that there is no set limit - its more dependent on
> the number of variables, levels etc
>
> HTH
> --
> ===========================================
> Connor McDonald
> "These views mine, no-one elses etc etc"
> connor_mcdonald_at_yahoo.com
>
> "Some days you're the pigeon, and some days you're the statue."
Received on Tue Dec 14 1999 - 00:21:23 CST