Re: PS/SQL - "program too large"

>> ...anyone come across PLS-123 compilation
>> error "Program too large."

Hi Rick,

I ran into this problem customizing Oracle's Consolidated BOM report. What worked for me was to break the routine up into sub-routines(packages) and just call the package. IE: mypackage.subroutine. Since I have not done any web apps I don't know if this suggestion is of much help.

I think the max block size is 64K (???).

Good luck. Let me know if it works...

Alex Jentilucci - Consultant
Information System Dynamics, Inc
Minneapolis, MN 55323
Tele: 612-476-7395 FAX: 612-473-5954 E-Mail: infosys_at_aol.com

E-Mail Work: jentilucci_at_notes.seagate.com

          Home: AlexJent_at_aol.com Received on Fri Jan 31 1997 - 00:00:00 CST