| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: pls-00123 - Program too Large
You can find some info about this (regarding size limitations in different
oracle versions) in
http://www.itsystems.lv/gints/oracle_limits.htm
Gints Plivna
"Imma C.
Rocco" To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
<imma_at_lycos.c cc:
om> Subject: pls-00123 - Program too Large
Sent by:
root_at_fatcity.
com
2001.07.16
09:10
Please
respond to
ORACLE-L
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-LReceived on Mon Jul 16 2001 - 02:19:57 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: G.Plivna_at_itsystems.lv 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).
 |
 |