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 |
TNS-01108: Listener password prompt failed
RMAN-06570: datafile number switched to datafile copy "string"
AMD-00122: dimension #string: analytic workspace hierarchy dimension not specified
QSM-02188: named view in FROM list not supported for this type MV
ORA-00830: cannot set statistics_level to BASIC with auto-tune SGA enabled
ORA-27500: inter-instance IPC error
EXP-00083: The previous problem occurred when calling string.string.string
ORA-23502: valid directory for offline instatiation is not specified
ORA-39038: Object path "string" is not supported for string jobs.
TNS-00132: COST value must be an integer greater than 0
IMG-00713: unsupported destination image format
UDI-00050: unable to setup parameter processing.