PLS-00492: variable or constant initialization may not refer
to functions declared in the same package



PLS-00492: variable or constant initialization may not refer to functions declared in the same pack..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-12605: datatype of column number in COLUMNS list is not supported

1 Answers  


ORA-01097: cannot shutdown while in a transaction - commit or rollback first

1 Answers  


ORA-35756: (VCTODT02) 'number' is not a valid date because number is out of range for a year.

1 Answers  


ORA-02834: Server unable to open file

1 Answers  


ORA-16067: activation identifier mismatch in archive log string

1 Answers  


ORA-13707: Either the start snapshot string or the end snapshot string is incomplete or missing key statistics.

1 Answers  


EXP-00082: Invalid function name passed to procedural object support: string

1 Answers  


ORA-01665: controlfile is not a standby controlfile

1 Answers  


ORA-07268: szguns: getpwuid error.

1 Answers  


NCR-04005: NCRR: Invalid procedure handle

1 Answers  


ORA-13403: invalid rasterDataTable specification

1 Answers  


ORA-19656: cannot backup, copy, or delete online log string

1 Answers  


Categories