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-36391: (XSMXCLEA01) When CLEAR is used with the STATUS keyword or an AGGMAP, workspace object must be dimensioned identically to workspace object.
NNL-00805: Queries received, type NAME-SERVER: number
ORA-01870: the intervals or datetimes are not mutually comparable
NNL-00258: Server-generated requests currently do not require authoritative answers
ORA-16040: standby destination archive log file is locked
ORA-25176: storage specification not permitted for primary key
ORA-12723: regular expression too complex
ORA-01548: active rollback segment 'string' found, terminate dropping tablespace
ORA-24780: cannot recover a transaction while in an existing transaction
ORA-01259: unable to delete datafile string
ORA-14025: PARTITION may not be specified for a materialized view or a materialized view log
ORA-06449: The list IO or the sysvendor is not installed.