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-54651CREATE_TIN: invalid parameters specified in creation of TIN
RMAN-08038channel string: starting piece string at string
ORA-14618cannot drop the last value of subpartition
QSM-00516illegal status detected for run
ORA-29472DBMS_SQL.OPEN_CURSOR failed. security_level is outside the valid range of 0 to 2
PGU-39122EP number, string, string
ORA-29262bad URL
ORA-01761DML operation does not map to a unique table in the join
ORA-15117command only operates on one diskgroup
ORA-13403invalid rasterDataTable specification: string
RMAN-07516Reason: Error reading
ORA-08278Cannot get CPU statistics
ORA-01883overlap was disabled during a region transition
DRG-10584failed to string string string due to an Oracle error
ORA-13618The specified value is not a valid value for procedure argument string.
PLS-01452This function is not part of the ANSI standard
ORA-23315repcatlog version or request string is not supported by version string
TNS-00222-------------------------------------------------------------------
OCI-22055unknown sign flag value [string]
ORA-23333column string is already part of a column group




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-16665timeout waiting for the result from a database
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-16766Redo Apply is stopped
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-00001unique constraint (string.string) violated
ORA-55508Invalid input to Flashback Transaction Backout




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