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

ORA-32128: setDataBuffer called after fetch has started

1 Answers  


ORA-01580: error creating control backup file string

1 Answers  


LPX-00271: FTP login failed: ~s

1 Answers  


ORA-00154: protocol error in transaction monitor

1 Answers  


DRG-11600: URL store: string has permanently moved

1 Answers  


ORA-01479: last character in the buffer is not Null

1 Answers  


ORA-39149: cannot link privileged user to non-privileged user

1 Answers  


ORA-29892: indextypes with array DML do not support the given data type

1 Answers  


ORA-26718: transaction limit reached

1 Answers  


PLS-01473: Use <> instead of != or ~=

1 Answers  


IMG-00854: internal image data free failed

1 Answers  


ORA-16589: Data Guard Connection process detected a network transfer error

1 Answers  


Categories