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-26084: direct path context already finished

0 Answers  


ORA-22998: CLOB or NCLOB in multibyte character set not supported

1 Answers  


NID-00372: Change database ID and database name string to string? (Y/[N]) =>

1 Answers  


ORA-29542: class string already defined by source string

1 Answers  


ORA-14281: CHECK constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION

1 Answers  






TNS-04063: Remote administration disabled in the Oracle Connection Manager instance.

1 Answers  


EXP-00028: failed to open string for write

1 Answers  


EXP-00051: "string" - given partition or subpartition name is not part of "string" table

1 Answers  


ORA-14079: illegal option for a partition marked Index Unusable

1 Answers  


LPX-00006: invalid child type for parent node

1 Answers  


ORA-30006: resource busy; acquire with WAIT timeout expired

1 Answers  


ORA-21614: constraint violation for attribute number [string]

1 Answers  


Categories