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

LPX-00003: duplicate entry in hash table

1 Answers  


ORA-30431: refresh method must be ANY or INCREMENTAL or FORCE_FULL, not string

1 Answers  


DRG-10574: failed to upgrade text index string

1 Answers  


DRG-11708: too many thesauri

1 Answers  


RMAN-06904: backup of log thread number seq number lowscn string was cancelled

1 Answers  






ORA-13441: GeoRaster metadata SRS error

1 Answers  


PLS-00923: native compilation failed: string:string

1 Answers  


ORA-10635: Invalid segment or tablespace type

1 Answers  


QSM-00779: the specified directive conflicts with the existing directive string

1 Answers  


ORA-02424: potential circular view references or unknown referenced tables

1 Answers  


TNS-01046: Saved string configuration parameters.

1 Answers  


ORA-04083: invalid trigger variable 'string'

1 Answers  


Categories