PLS-00125: type name expected
Cause: When a constant or variable was declared, its datatype was not specified. For example, the code might look like pi CONSTANT := 3.14159; -- should be CONSTANT REAL := 3.14159 Every constant and variable must have a datatype, which specifies a storage format, constraints, and valid range of values.
Action: Supply the type name
PLS-00126
Custom Search


More Oracle errors
KUP-04102record number discarded from file string
RMAN-06738database name "string" is not unique in the recovery catalog
ORA-32828Messaging Gateway agent must be running
QSM-02016clustered table in FROM list
OCI-31180DOM Type mismatch in invalid PL/SQL DOM handle
DIA-51025check name should be non NULL value
ORA-31494could not activate a LogMiner session
ORA-02031no ROWID for fixed tables or for external-organized tables
QSM-01346general inline view rewrite not possible with nested inline views
ORA-16598Data Guard broker detected a mismatch in configuration
ORA-37411invalid object type
ORA-23323parameter length exceeds deferred RPC limits
NNL-00348Server saving the config file now
PCC-02447Cannot specify destination offset in a LOB WRITE APPEND
PLS-00731ALTER TYPE is supported only on schema-level types
OCI-19200Invalid column specification
ORA-07561szprv: $IDTOASC failure
QSM-00786the name string is invalid for directive string
ORA-39168Object path string was not found.
ORA-12732invalid interval value in regular expression




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-00125type name expected