Re: Dealing with size limitations in PL/SQL
Date: 1996/01/08
Message-ID: <30F12B8D.55AD_at_us.oracle.com>#1/1
Justina Seet wrote:
>
> Problem
> -------
>
> Two days ago, I encountered an error message :
> ORA-06501 PL/SQL :internal error,arguments :[ ] , [ ] , [ ] , [ ] , [ ] ,
> [ ], [ ] while compiling my recomputation program.
>
> Cause
> -----
> I called Oracle hotline and found this out : PL/SQL compiler imposes a
> limit on program size. Programs that exceed the limit cause a "program
> too large" compilation error.
>
> Solution
> --------
> Between the BEGIN and END of a program, maximum 64K compiled code is
> allowed. The best solution to this problem is to modularize program by
> defining subprograms or packages.
>
> Question
> --------
> Does anyone know of another solution instead of having to divide my
> package into 2 or more packages ?"
This is only a limitation with the 16-bit windows products. It does not occur on unix, vms, ...
The 32-bit version (whenever that is) should solve that.
-- _________________________________________________ Robert C. Nix Oracle Tools Support rnix_at_us.oracle.com DISCLAIMER: The thoughts, opinions, remarks, suggestions, ... expressed herein are my own and in no way should be taken as a statement from Oracle Corporation. I am NOT the voice of Oracle (not even close!).Received on Mon Jan 08 1996 - 00:00:00 CET