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-12214: TNS:missing local communities entry in TNSNAV.ORA

1 Answers  


NNL-00918: Time until server restart: string

1 Answers  


SQL*Loader-00408: Physical record stack overflow

1 Answers  


DRG-11532: error reading through end of line string for file string

1 Answers  


ORA-28274: No ORACLE password attribute corresponding to user nickname exists.

1 Answers  


ORA-01486: size of array element is too large

1 Answers  


ORA-14053: illegal attempt to modify string in string statement

1 Answers  


ORA-16717: clearing parameter LOG_ARCHIVE_DUPLEX_DEST failed

1 Answers  


ORA-13705: There was a instance shutdown/startup between the snapshots in the range [string, string].

1 Answers  


ORA-24160: name string already exists in the name value pair list

1 Answers  


PCC-02416: The Object in an OBJECT GET or SET must not be an array

1 Answers  


TNS-12681: Login failed: the SecurID card does not have a pincode yet

1 Answers  


Categories