Re: Dealing with size limitations in PL/SQL

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!).