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

DRG-10503: table string cannot be indexed because it has no primary key

1 Answers  


RMAN-08532: channel string: restoring block(s) from datafilecopy string

1 Answers  


ORA-07565: sldext: $SEARCH failure

1 Answers  


DRG-11219: malformed mail configuration file, line string

1 Answers  


TNS-04045: Invalid specification of time

1 Answers  


ORA-31493: could not prepare session for LogMiner session

1 Answers  


ORA-07625: smsget: $MGBLSC failure

1 Answers  


ORA-25966: join index cannot be based on an index organized table

1 Answers  


PLS-00729: only widening of the collection element type is allowed

1 Answers  


ORA-14253: table is not partitioned by Composite Range method

1 Answers  


ORA-30551: The index depends on a package/type body which does not exist

1 Answers  


DRG-10834: upper-case form of section name string too long

1 Answers  


Categories