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-00487: Invalid reference to variable 'string'



PLS-00487: Invalid reference to variable 'string'..

Answer / guest

Cause: A variable was referenced in a way that is
inconsistent with its datatype. For example, a scalar
variable might have been mistakenly referenced as a record,
as follows: DECLARE CURSOR emp_cur IS SELECT empno, ename,
sal FROM emp; emp_rec emp_cur%ROWTYPE; my_sal NUMBER(7,2);
BEGIN ... total_sal := total_sal + my_sal.sal; -- invalid ...

Action: Check the spelling of the variable name. Make sure
the variable was declared properly and that the declaration
and reference are consistent regarding datatype.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00223: paramaterless procedure 'string' used as function

1 Answers  


RMAN-06079: database must be mounted to perform recovery

1 Answers  


O2F-00341: An error occurred for which no message is available

1 Answers  


ORA-14635: only one resulting subpartition can be specified for MERGE SUBPARTITIONS

1 Answers  


PLS-00146: duplicate external TRUSTED/UNTRUSTED specification in subprogram expression

1 Answers  


RMAN-08506: input filename=string

1 Answers  


ORA-16411: ONDEMAND archival requires active managed recovery operation

1 Answers  


DRG-11828: Conflict

1 Answers  


ORA-40216: feature not supported

1 Answers  


ORA-06730: TLI Driver: unable to open clone device

1 Answers  


DRG-50600: assertion failed

1 Answers  


SQL*Loader-00434: Can not load LOB/XML in a nested table along with the parent table.

1 Answers  


Categories