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-25175: no PRIMARY KEY constraint found
ORA-19900: RESETLOGS must be specified after recovery to new incarnation
TNS-12165: TNS:Trying to write trace file into swap space.
ORA-07512: sscggtl: $enq unexpected return for client termination lock
ORA-36677: (XSDPART15) Duplicate value in value lists of number and number
ORA-02173: invalid option for DROP TABLESPACE
PLS-00314: TABLE declarations are not allowed as PL/SQL local variables
ORA-24414: Only number sessions could be started.
ORA-34177: (MXCHGDCL19) number cannot be deleted because one or more partitioned variables instantiate it.
EXP-00057: Failure to initialize parameter manager
RMAN-06100: no channel to restore a backup or copy of datafile number
PCC-02435: This attribute is only valid for internal LOB types