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-22346: Type has cyclical dependency. Should use CASCADE option

1 Answers  


ORA-36808: (XSTBLFUNC04) The OLAP_TABLE function LEVELREL clause cannot declare number ADT fields from number AW fields.

1 Answers  


PROC-00025: Error in the NLS services

1 Answers  


ORA-12985: tablespace 'string' is read only, cannot drop column

1 Answers  


ORA-22275: invalid LOB locator specified

1 Answers  


ORA-13201: invalid parameters supplied in CREATE INDEX statement

1 Answers  


DRG-11404: no primary key value specified

1 Answers  


AUD-00803: internal error while processing WHERE clause

1 Answers  


ORA-38310: cannot purge tablespace for other users

1 Answers  


ORA-01939: only the ADMIN OPTION can be specified

1 Answers  


ORA-24950: unregister failed, registeration not found

1 Answers  


ORA-16046: Archive log destination failed due to failed dependent destination

1 Answers  


Categories