| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> pls-00123 - Program too Large
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: imma_at_lycos.com
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: ListGuru_at_fatcity.com (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). Received on Mon Jul 16 2001 - 01:10:16 CDT
 |
 |