PLS-00123: program too large
Answer / guest
Cause: PL/SQL was designed primarily for robust transaction
processing. One consequence of the special-purpose design is
that the PL/SQL compiler imposes a limit on block size. The
limit depends on the mix of statements in the PL/SQL block.
Blocks that exceed the limit cause this error.
Action: The best solution is to modularize the program by
defining subprograms, which can be stored in an Oracle
database. Another solution is to break the program into two
sub-blocks. Have the first block INSERT any data the second
block needs into a temporary database table. Then, have the
second block SELECT the data from the table.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-14405: partitioned index contains partitions in a different tablespace
ORA-39114: Dump files are not supported for string jobs
NNO-00809: Unknown OCI error: number
NNC-00004: connection is broken
ORA-13441: GeoRaster metadata SRS error
ORA-12901: default temporary tablespace must be of TEMPORARY type
ORA-08207: ora_addr: cannot open address file
NZE-29032: The given identity is not complete.
ORA-27010: skgfwrt: write to file failed
QSM-02063: aggregate function in mv
KUP-03004: absolute end (number) specified with relative start (number) for field string
SQL*Loader-00471: OID or SID clause has an argument that is CONSTANT