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:40:22 GMT
Message-ID: <YS0e2.4712$lT5.865_at_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.
Received on Thu Dec 17 1998 - 07:40:22 CET
Date: Thu, 17 Dec 1998 06:40:22 GMT
Message-ID: <YS0e2.4712$lT5.865_at_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?
Arnold A Mavromatis
A/SITOC NCC/SRCC
Mail: aam_at_bom.gov.au
Phone: 9669 4016
Received on Thu Dec 17 1998 - 07:40:22 CET