Re: PS/SQL - "program too large"

From: Ian Mckenzie <ian.mckenzie_at_cit.act.edu.au>
Date: 1997/02/03
Message-ID: <32F5422C.5269@cit.act.edu.au>#1/1

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.

Ian Mckenzie Received on Mon Feb 03 1997 - 00:00:00 CST