PLS-00492: variable or constant initialization may not refer
to functions declared in the same package
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 |
ORA-22310: ALTER TYPE error. Refer to table "string"."string" for errors
ORA-16138: end of log stream not received from primary
ORA-24365: error in character conversion
DRG-12508: null stop words are not allowed
NZE-28830: no identity type specified
ORA-30104: 'string' is not a legal integer for 'string'
ORA-13025: polygon does not close
PCC-02303: cannot open include file
ORA-14329: domain index [sub]partitions cannot be renamed in this clause
ORA-02315: incorrect number of arguments for default constructor
ORA-14118: CHECK constraint mismatch in ALTER TABLE EXCHANGE PARTITION
ORA-15010: name is already used by an existing ASM disk