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-06501: skipping datafile string; already backed up on string

1 Answers  


PCB-00009: Cannot change MAXLITERAL after an EXEC SQL statement

1 Answers  


RMAN-06069: the filename for datafile string is missing in the controlfile

1 Answers  


ORA-28604: table too fragmented to build bitmap index (string,string,string)

1 Answers  


ORA-30115: error when processing an environment variable

1 Answers  


ORA-02830: Segment could not be split - no free segments available

1 Answers  


ORA-00370: potential deadlock during kcbchange operation

1 Answers  


TNS-00113: Failed to open error log file

1 Answers  


ORA-32634: automatic order MODEL evaluation does not converge

1 Answers  


ORA-29662: Unable to find a field that matches one or more of the attributes

1 Answers  


KUP-03005: relative end (number) specified does not match fieldlen(number) for field string

1 Answers  


ORA-02484: Invalid _trace_buffers parameter specification (string)

1 Answers  


Categories