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

TNS-00292: Log File Name : string

1 Answers  


ORA-13701: Snapshot pair [string, string] seems to be specified in reverse order.

1 Answers  


NNL-00400: Response status:

1 Answers  


LSX-00242: bad Boolean "~S"

1 Answers  


ORA-36670: (XSDPART08) workspace object is an INTEGER or NTEXT dimension, or contains an INTEGER or NTEXT dimension. INTEGER and NTEXT dimensions cannot be used as partition dimensions.

1 Answers  


ORA-40209: setting % is invalid for % function

1 Answers  


TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

1 Answers  


RMAN-10038: database session for channel string terminated unexpectedly

1 Answers  


ORA-09313: slsprom: error prompting user

1 Answers  


ORA-31456: error executing a procedure in the DBMS_CDC_UTILITY package

1 Answers  


ORA-01483: invalid length for DATE or NUMBER bind variable

1 Answers  


ORA-19572: cannot process file string, file is being being resized

1 Answers  


Categories