PLS-00487: Invalid reference to variable 'string'
- 1 Answers
- 4916 Views
- I also Faced
- E-Mail Answers
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 |
QSM-00514: the size of must-retain summaries exceeds specified space limit
PROT-00304: Failed to create dump file
LSX-00125: "restriction" element is improperly defined
ORA-26079: file "string" is not part of table string.string
DRG-11611: URL store: unknown protocol specified in string
TNS-04017: Please wait. Shutdown in progress.
NZE-28824: invalid encryption/decryption/signature state passed
ORA-01953: command no longer valid, see ALTER USER
ORA-09266: spawn: error starting an Oracle process
ORA-25504: the system is already in quiesced state
IMG-00807: no weights specified in weight string
PCC-02328: undefined struct member
Oracle Errors 
