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-14281: CHECK constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION

1 Answers  


ORA-31498: description and remove_description cannot both be specified

1 Answers  


NCR-02008: NCRF: Error within stream processing in format interpreter

1 Answers  


ORA-09753: spwat: invalid process number.

1 Answers  


ORA-01209: data file is from before the last RESETLOGS

1 Answers  


ORA-24155: rule string.string not in rule set string.string

1 Answers  


ORA-36378: (XSAGTHRWEIGHT) While running AGGREGATE with multiple threads, the weight variable workspace object specified by your ARGS variable workspace object must exist in the same analytic workspace as your AGGMAP workspace object.

1 Answers  


QSM-02002: DISTINCT aggregate measure in SELECT list

1 Answers  


ORA-01572: rollback segment 'string' cannot be brought online, string extents exceeded

1 Answers  


TNS-01409: Instance "string"

1 Answers  


TNS-02520: encryption/crypto-checksumming: no Diffie-Hellman seed

1 Answers  


ORA-00910: specified length too long for its datatype

1 Answers  


Categories