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-30573: AUTO segment space management not valid for this type of tablespace

1 Answers  


ORA-16063: remote archival is enabled by another instance

1 Answers  


ORA-19654: must use backup controlfile to switch file incarnations

1 Answers  


ORA-06443: ssvpstev: Incorrect parameter passed to function call

1 Answers  


PLS-00131: Pragma string expects 2nd argument to be a procedure

1 Answers  


ORA-24155: rule string.string not in rule set string.string

1 Answers  


ORA-31641: unable to create dump file "string"

1 Answers  


PCC-01200: You are not authorized to run Pro*C

1 Answers  


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

1 Answers  


ORA-27190: skgfrd: sbtread2 returned error

1 Answers  


TNS-04087: Unable to shutdown atleast one of the gateways.

1 Answers  


ORA-38900: missing mandatory column "string" of error log table "string"

1 Answers  


Categories