PLS-00492: variable or constant initialization may not refer to functions declared in the same package
Cause: If a package spec p declares a function f, that function may not be used in any variable declarations in that same package spec. This is because of a circular instantiation problem: in order to fully instantiate the package spec, the variable must be initialized. To initialize the variable, the function body code in the package body must be executed. That requires that the package body be instantiated. However, the package body cannot be instantiated until the package spec is fully instantiated.
Action: Remove the reference to the function from the variable initialization. A technique which often works is to move the variable initialization from the variable declaration (in the package spec) to the package body initialization block.
PLS-00493
Custom Search


More Oracle errors
ORA-23345table "string"."string" not registered to collect statistics
ORA-22332a dependent object in schema "string" has errors. string
O2U-00211A type without attributes was translated
ORA-32775cannot change size attributes of read only tablespace string
ORA-32635not a single cell reference predicate
ORA-07449sc: usnewlock failed.
ORA-16431Cannot expand control file
TNS-01300ERROR at string
ORA-29911null scan context returned by ODCIIndexStart() routine
RMAN-05018some datafile copies cannot be recovered, aborting the RECOVER command
NNC-00051message content error
EVM-00315Forwarder "string" re-enabled
ORA-35076(QFHEAD04) CAUTION: The textual data in EIF file string is encoded in a character set that is not recognized by this version of string.
LPX-00772wrong object type
NNL-00212Cache checkpointing is now disabled
ORA-29325SET COMPATIBILITY release number lower than string
ORA-53250Mapping document does not exist.
ORA-30191missing argument list
ORA-00085current call does not exist
ORA-26030index string.string had string partitions made unusable due to:




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-00492variable or constant initialization may not refer to functions declared in the same package