Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-22310: ALTER TYPE error. Refer to table "string"."string" for errors

1 Answers  


ORA-16138: end of log stream not received from primary

1 Answers  


ORA-24365: error in character conversion

1 Answers  


DRG-12508: null stop words are not allowed

1 Answers  


NZE-28830: no identity type specified

1 Answers  


ORA-30104: 'string' is not a legal integer for 'string'

1 Answers  


ORA-13025: polygon does not close

1 Answers  


PCC-02303: cannot open include file

1 Answers  


ORA-14329: domain index [sub]partitions cannot be renamed in this clause

1 Answers  


ORA-02315: incorrect number of arguments for default constructor

1 Answers  


ORA-14118: CHECK constraint mismatch in ALTER TABLE EXCHANGE PARTITION

1 Answers  


ORA-15010: name is already used by an existing ASM disk

1 Answers  


Categories