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-19679: RMAN configuration number string is outside valid range of 1 through string
ORA-07416: slpath: pathname construction failed; lack of output buffer space.
ORA-32150: Cannot perform operation on a null timestamp
ORA-39130: Object type string not imported. Base object name conflicts with the master table
ORA-02351: internal error: string
ORA-32024: invalid directory specified for audit_file_dest parameter
NNO-00313: server password length string exceeds maximum of string
ORA-28546: connection initialization failed, probable Net8 admin error
ORA-29832: cannot drop or replace an indextype with dependent indexes
ORA-08467: error converting Oracle number to string
LFI-01514: ftell() failed in string
NID-00416: Change of database name failed.