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 |
ORA-30573: AUTO segment space management not valid for this type of tablespace
ORA-16063: remote archival is enabled by another instance
ORA-19654: must use backup controlfile to switch file incarnations
ORA-06443: ssvpstev: Incorrect parameter passed to function call
PLS-00131: Pragma string expects 2nd argument to be a procedure
ORA-24155: rule string.string not in rule set string.string
ORA-31641: unable to create dump file "string"
PCC-01200: You are not authorized to run Pro*C
ORA-16589: Data Guard Connection process detected a network transfer error
ORA-27190: skgfrd: sbtread2 returned error
TNS-04087: Unable to shutdown atleast one of the gateways.
ORA-38900: missing mandatory column "string" of error log table "string"