Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-02752: osnfsmmap: illegal shared memory address

1 Answers  


PCC-01300: You are not authorized to run Pro*PL/I

1 Answers  


TNS-04014: Current instance string is already started

1 Answers  


IMG-00544: invalid compressionQuality specified

1 Answers  


ORA-02773: Invalid maximum client wait time

1 Answers  






TNS-01441: Number of filtering rules currently in effect: number

1 Answers  


ORA-01512: error renaming log file string - new file string not found

1 Answers  


ORA-13361: not enough sub-elements within a compound ETYPE

1 Answers  


ORA-24389: Invalid scrollable fetch parameters

1 Answers  


ORA-26672: timeout occurred while stopping STREAMS process string

1 Answers  


DRG-10580: parallel indexing is not supported: string

1 Answers  


RMAN-06454: duplexed backups require Enterprise Edition

1 Answers  






Categories