PLS-00123 Program too large error.. how to get around it?

From: Arnold Mavromatis <aam_at_bom.gov.au>
Date: Thu, 17 Dec 1998 06:38:14 GMT
Message-ID: <XQ0e2.4711$lT5.865@vic.nntp.telstra.net>

I have a procedure that needs to be very lengthy by its very nature. I decoding lots of user options from a web form that OWS generated and using the inputs to drive a massively dynamic product across 3 tables. The output of which goes to a file.

I'm only 1/4 the way through the decoding parts and I get the error message PLS-00123 program too large.

I tried breaking the program into smaller parts when encapsulating the work in a package with global variables for inter-function/procedure communication but I sonn ran into the same error after another thousand lines of code.

Does anyone know how to get around this? Received on Thu Dec 17 1998 - 00:38:14 CST