We have a tool (an own-made pl/sql code generator) whose purpose
is to generate a PL/SQL Package containing one pls function for
each Table/View that has been configured in a specific repository table.
Depending on the number of table/view configured the package dimension
grows. Compiling one of those automatically generated packages we
got the following error PLS-00123 - Program too Large.
Obviously one of the possible solution to the the problem is to
modularize, but depending of the fact that the package code is automatically
generated this could not work.
Could someone give us a more detailed explanation on why this error
occurs and eventually a possible solution.
I've read somethings about an existing correlation between Oracle
Block_size and PL/SQL block size - has anyone more detailed information about this?
Is it possible to determine in a unique way the max dimension a pl/sql package can
have?
Thanks in advance
Imma
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Imma C. Rocco
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
