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-25504: the system is already in quiesced state
ORA-13120: invalid face_id [string]
ORA-14094: invalid ALTER TABLE EXCHANGE PARTITION option
NZE-29014: Maximum fragment length extension is incorrect.
QSM-01610: a lossy join in equivalence, string, between tables, string, not found in query
TNS-12611: TNS:operation is not portable
ORA-06033: NETDNT: connect failed, partner rejected connection
ORA-36708: (XSMXALLOC00) Variable workspace object must be dimensioned to be used by the ALLOCATE command.
ORA-38722: ON or OFF expected.
ORA-08101: index key does not exist file string: (root string, node string) blocks (string)
QSM-01107: Partition Containment Tracking (PCT) rewrite is not allowed
TNS-04070: Cannot administer a remote Oracle Connection Manager instance which is not yet started.