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

QSM-02044: ORDER BY clause in mv

1 Answers  


CLSS-03000: reconfiguration successful, incarnation string with string nodes

1 Answers  


ORA-29394: session id string and serial# string do not exist

1 Answers  


ORA-02195: Attempt to create string object in a string tablespace

1 Answers  


ORA-09779: snyGetPort: failure to allocate a port.

1 Answers  


ORA-16526: unable to allocate task element

1 Answers  


TNS-12519: TNS:no appropriate service handler found

1 Answers  


ORA-19812: cannot use string without DB_RECOVERY_FILE_DEST

1 Answers  


ORA-29914: ODCIGETINTERFACES routine does not return required stream version

1 Answers  


ORA-16774: Error in stopping the physical apply service (MRP process)

1 Answers  


PCB-00100: Unable to reopen temporary file string

1 Answers  


ORA-39138: Insufficient privileges to load data not in your schema

1 Answers  


Categories