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
RMAN-00579SCRIPT cannot be used with CMDFILE
ORA-16176background dictionary build cannot be running
TNS-04011Oracle Connection Manager instance not yet started.
SQL*Loader-00965Error number disabling constraint string on table string
ORA-19230XPST0010 - unsupported axis string
ORA-14264table is not partitioned by Composite Range method
IMP-00039VOLSIZE does not match the value used for export: string
ORA-01491CASCADE option not valid
PGU-39101RP rc %4li
ORA-25002cannot create INSTEAD OF triggers on tables
KUP-04090big endian byte order mark found when little endian expected in string
ORA-16079standby archival not enabled
ORA-38818illegal reference to versionable object string.string
ORA-24435Invalid Service Context specified.
DRG-11007multiple stopwords specified
NNO-00617enabling AUTHORITY-REQUIRED on system queries
ORA-35018(QFCHECK01) The analytic workspace and EIF file definitions of workspace object have a mismatched data type.
ORA-10643Database should be mounted in restricted mode and Exclusive mode
ORA-35917(XSHIDE05) You cannot HIDE model workspace object because the analytic workspace in which it is defined has not been upgraded to version string.
TNS-01191Failed to initialize the local OS authentication subsystem




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