PLS-00487: Invalid reference to variable 'string'



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

Post New Answer

More Oracle Errors Interview Questions

ORA-16408: Incompatible archival Redo Branch lineage

1 Answers  


ORA-31620: file or device "string" cannot be specified for string operation

1 Answers  


ORA-12335: database (link name string) is not open

1 Answers  


NNL-00558: set|show namesctl_trace_level : set|show the controller's tracing level

1 Answers  


ORA-10633: No space found in the segment

1 Answers  






ORA-06750: TLI Driver: sync failed

1 Answers  


ORA-25266: didnt try to dequeue by message id. with the signature

1 Answers  


DRG-50804: failed to exec cursor

1 Answers  


ORA-19036: Invalid query result set in newContextFromHierarchy()

1 Answers  


ORA-07800: slbtpd: invalid number

1 Answers  


ORA-14065: ALLOCATE STORAGE may not be specified for a partitioned table

1 Answers  


SQL*Loader-00108: Invalid number of logical records to load

1 Answers  


Categories