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-25175: no PRIMARY KEY constraint found

1 Answers  


ORA-19900: RESETLOGS must be specified after recovery to new incarnation

1 Answers  


TNS-12165: TNS:Trying to write trace file into swap space.

1 Answers  


ORA-07512: sscggtl: $enq unexpected return for client termination lock

1 Answers  


ORA-36677: (XSDPART15) Duplicate value in value lists of number and number

1 Answers  


ORA-02173: invalid option for DROP TABLESPACE

1 Answers  


PLS-00314: TABLE declarations are not allowed as PL/SQL local variables

1 Answers  


ORA-24414: Only number sessions could be started.

1 Answers  


ORA-34177: (MXCHGDCL19) number cannot be deleted because one or more partitioned variables instantiate it.

1 Answers  


EXP-00057: Failure to initialize parameter manager

1 Answers  


RMAN-06100: no channel to restore a backup or copy of datafile number

1 Answers  


PCC-02435: This attribute is only valid for internal LOB types

1 Answers  


Categories