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-39057: invalid worker request string for string jobs.

1 Answers  


ORA-39041: Metadata filter has no selectivity.

1 Answers  


NNC-00053: ASN.1 error encountered while sending or receiving message

1 Answers  


ORA-30345: circular dimension hierarchy

1 Answers  


ORA-31403: change table string already contains a column string

1 Answers  


ORA-32839: property string is reserved, names with MGWPROP$_ prefix are not valid

1 Answers  


TNS-12234: TNS:Redirect to destination

1 Answers  


PLS-00524: The parameter type in an ORDER method must be the containing object type.

1 Answers  


ORA-24327: need explicit attach before authenticating a user

1 Answers  


TNS-00280: Max Avg Bytes/Sec : number

1 Answers  


ORA-30676: socket read or write failed

1 Answers  


ORA-10653: Table is in a cluster

1 Answers  


Categories