Re: PL/SQL program size limit

In article <1992Mar2.055737.11082_at_cnw01.storesys.coles.oz.au>, ltan_at_cnw01.storesys.coles.oz.au (Lay Tan) writes:
> My developers are encountering a problem with PL/SQL. It seems that
> there is a PL/SQL program size limit. ...
> ...
> However, for both users, as soon as they cut down on their coding, eg. in
> the first user's case down to 41Kb in size, it compiled okay. Is there any
> thing we can do to resolve this problem or is there a guide to the actual limit

We encountered a similar problem, and reported it to Oracle as a bug. Their response was that there is indeed a program length limit, but that their new version of PL/SQL had a larger limit which should fix our problem. True, the new version of PL/SQL had a larger limit, but we ran into that one as well. Sorry, I don't remember the exact version numbers we were using at the time, but we are currently running Oracle version 6.0.32.3 with PL/SQL version 1.0.32. The size limit with this version of PL/SQL has been about 1000-1200 lines of code, but I don't know how many Kb that works out to.

Oracle did tell us that they are trying to get rid of this limit. With luck, we will get it fixed when we upgrade to Version 7. Received on Tue Mar 03 1992 - 18:07:28 CET