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-25269: cant specify sognature with get signature option
ORA-31661: there are no metadata transform values of type VARCHAR2
PLS-01714: ANSI expects a column name not a literal value here
ORA-25210: invalid value for RELATIVE_MSGID, no message in queue with that msgid
ORA-07718: sksafre: error freeing memory
PLS-00609: the OVERRIDING clause is not valid for SQLJ Object Types
ORA-01518: CREATE DATABASE must specify more than one log file
PLS-00907: cannot load library unit string (referenced by string)
ORA-13184: failed to initialize tessellation package
ORA-02320: failure in creating storage table for nested table column string
ORA-25117: MIN/MAX/Block Number expected
ORA-16582: Could not edit instance specific property.