Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PS/SQL - "program too large"
Ian Mckenzie wrote:
>
> Rich Hoffman wrote:
> >
> > Folks -
> > ...anyone come across PLS-123 compilation
> > error "Program too large."
> > Seems to mean one of the PL/SQL blocks is too large ...
> > unfortunately since it is a web app, I can't break it
> > down without major inconvenience. I tried using
> > anonynmous blocks nested within
> > but that didn't work... Any ideas?
> >
> You have 64 K to play with so if you have comments in the code get rid
> of them as well as any blank lines, if this still is not enougth you
> will have to start having multiple commands per line.
64k what exactly? lines? I've compiled packages/procedures that were thousands of lines long and hundreds of thousands of bytes without a problem.
-James Rogers
jamesr_at_best.com
Received on Tue Feb 04 1997 - 00:00:00 CST