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

ORA-02096: specified initialization parameter is not modifiable with this option

1 Answers  

---

PLS-00126: selector ALL is not allowed

1 Answers  

---

NZE-28820: Signature or decryption/encryption state is not provided.

1 Answers  

---

PCC-02391: Runtime context variable not of correct type

1 Answers  

---

ORA-21709: cannot refresh an object that has been modified

1 Answers  

---

ORA-24326: handle passed in is already initialized

1 Answers  

---

SQL-02118: Invalid row for a WHERE CURRENT OF operation

1 Answers  

---

NNC-00428: invalid meta-data data item

1 Answers  

---

ORA-38477: attribute set cannot be derived from an evolved type or a subtype.

1 Answers  

---

ORA-02052: remote transaction failure at string

1 Answers  

---

ORA-13829: SQL profile named string already exists

1 Answers  

---

PCC-00027: Redeclared SQL Identifier "string" at line number in file string

1 Answers  

---