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-36391: (XSMXCLEA01) When CLEAR is used with the STATUS keyword or an AGGMAP, workspace object must be dimensioned identically to workspace object.

1 Answers  


NNL-00805: Queries received, type NAME-SERVER: number

1 Answers  


ORA-01870: the intervals or datetimes are not mutually comparable

1 Answers  


NNL-00258: Server-generated requests currently do not require authoritative answers

1 Answers  


ORA-16040: standby destination archive log file is locked

1 Answers  






ORA-25176: storage specification not permitted for primary key

1 Answers  


ORA-12723: regular expression too complex

1 Answers  


ORA-01548: active rollback segment 'string' found, terminate dropping tablespace

1 Answers  


ORA-24780: cannot recover a transaction while in an existing transaction

1 Answers  


ORA-01259: unable to delete datafile string

1 Answers  


ORA-14025: PARTITION may not be specified for a materialized view or a materialized view log

1 Answers  


ORA-06449: The list IO or the sysvendor is not installed.

1 Answers  


Categories