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-00320: the declaration of the type of this expression is
incomplete or malformed



PLS-00320: the declaration of the type of this expression is incomplete or malformed..

Answer / guest

Cause: In a declaration, the name of a variable or cursor is
misspelled or the declaration makes a forward reference.
Forward references are not allowed in PL/SQL. A variable or
cursor must be declared before it is referenced it in other
statements, including other declarative statements. For
example, the following declaration of dept_rec raises this
exception because it refers to a cursor not yet declared:
DECLARE dept_rec dept_cur%ROWTYPE; CURSOR dept_cur IS SELECT
... ...

Action: Check the spelling of all identifiers in the
declaration. If necessary, move the declaration so that it
makes no forward references.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06230: List of Stored Scripts in Recovery Catalog

1 Answers  


NZE-29245: the toolkit does not recognize the function being used

1 Answers  


ORA-14160: this physical attribute may not be specified for a table subpartition

1 Answers  


ORA-23440: incorrect public template value

1 Answers  


ORA-16026: parameter string contains an invalid attribute value

1 Answers  


ORA-28134: object cannot have fine-grained access control policy

1 Answers  


SQL-02142: Collection is NULL

1 Answers  


ORA-14026: PARTITION and CLUSTER clauses are mutually exclusive

1 Answers  


DRG-11432: file error while accessing knowledge base

1 Answers  


LPX-00317: undefined decimal-format "~S"

1 Answers  


TNS-00554: write failed

1 Answers  


ORA-06809: TLI Driver: could not clear the IPX ethernet SAP at init

1 Answers  


Categories