PLS-00487: Invalid reference to variable 'string'
- 1 Answers
- 4392 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 |
DRG-12437: highlight table release failed
SQL*Loader-00486: sql-strings may not be specified for collection field string
ORA-26507: null master connection
ORA-32136: Cannot perform operation on an invalid stream
ORA-02009: the size specified for a file must not be zero
ORA-30030: suppress resumable related error message
DRG-52103: the Oracle Text environment could not reset
TNS-12678: Authentication disabled but required
PCC-01300: You are not authorized to run Pro*PL/I
LCD-00113: integer conversion error or negative integer [string]
RMAN-10031: RPC Error: ORA-number occurred during call to string.string
ORA-00356: inconsistent lengths in change description
Oracle Errors 
