| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Procedure too big?
Bill Cohagan wrote:
>
> 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."
For "esoteric" questions like this, I generally search Metalink (www.oracle.com/support) or technet.oracle.com
Cheers
Connor
--
"Some days you're the pigeon, and some days you're the statue." Received on Tue Dec 14 1999 - 07:48:20 CST
 |
 |