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

ORA-03236: max # extents (string) reached in index string.string subpartition string

1 Answers  


ORA-07408: slbtpd: overflow while converting to packed decimal.

1 Answers  


ORA-13120: invalid face_id [string]

1 Answers  


ORA-32626: illegal bounds or increment in MODEL FOR loop

1 Answers  


ORA-02299: cannot validate (string.string) - duplicate keys found

2 Answers  


ORA-01518: CREATE DATABASE must specify more than one log file

1 Answers  


SQL*Loader-02050: Multibyte character error.

1 Answers  


ORA-12813: value for PARALLEL or DEGREE must be greater than 0

1 Answers  


ORA-07210: slcpu: getrusage error, unable to get cpu time.

1 Answers  


PLS-01900: : character to number conversion error

1 Answers  


DRG-11706: invalid relation string

1 Answers  


QSM-01533: query rewritten with equivalence, string

1 Answers  


Categories