Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

ORA-09715: orasrv: cannot obtain puname

1 Answers  


ORA-25405: transaction status unknown

1 Answers  


ORA-01613: instance string (thread string) only has string logs - at least 2 logs required to enable.

1 Answers  


O2F-00324: Unable to convert from the database character set to the compiler character set

1 Answers  


NNL-00038: Distinguished Name syntax error

1 Answers  






RMAN-08116: output filename is original SPFILE location

1 Answers  


LSX-00248: invalid duration "~S"

1 Answers  


ORA-12570: TNS:packet reader failure

1 Answers  


IMG-00519: illegal combination of parameters

1 Answers  


ORA-01942: IDENTIFIED BY and EXTERNALLY cannot both be specified

1 Answers  


PLS-00374: illegal EXIT statement; it must appear inside the loop labeled 'string'

1 Answers  


ORA-37001: You have one or more attached but unupdated analytic workspaces.

1 Answers  






Categories