PLS-00123: program too large (string)
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.
PLS-00124
Custom Search


More Oracle errors
ORA-32625illegal dimension in cell reference predicate
OCI-31016Attempted to delete entry without name
QSM-02154MV is not fast refreshable even with view merging
ORA-37100(XSUNCOMMITTED) You have one or more updated but uncommitted analytic workspaces.
ORA-31074XML comment length string exceeds maximum string
NNO-00260loading configuration data from checkpoint file "string"
OCI-21710argument is expecting a valid memory address of an object
DRG-12511use ctx_ddl.create_stoplist to create stoplists
SQL*Loader-00105Invalid data file name on command line
ORA-21700object does not exist or is marked for delete
ORA-12684encryption/crypto-checksumming: Diffie-Hellman seed too small
ORA-32767No server connection for this operation
ORA-06258NETNTT: cannot allocate context area
PGU-42002COPY statement: ended prematurely
TNS-00222-------------------------------------------------------------------
ORA-13487SRID not found for source coordinate system metadata
QSM-01061illegal query expression
ORA-15246cannot bring ASM disk string both online and then offline in the same statement
NNL-00245General request processing is currently enabled
ORA-39954DEFERRED is required for this system parameter




TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
ORA-16766Redo Apply is stopped
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-16665timeout waiting for the result from a database
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-55508Invalid input to Flashback Transaction Backout
ORA-00001unique constraint (string.string) violated




Your own TOP 20 Oracle errors
PLS-00123program too large (string)