PLS-00403: expression 'string' cannot be used as an
INTO-target of a SELECT/FETCH statement
Answer / guest
Cause: A FETCH statement was unable to assign a value to an
assignment target in its INTO list because the target is not
a legally formed and declared variable. For example, the
following assignment is illegal because 'Jones' is a
character string, not a variable: FETCH my_cur INTO 'Jones';
Action: Check the spelling and declaration of the assignment
target. Make sure that the rules for forming variable names
are followed.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 2 No |
ORA-16008: indeterminate control file checkpoint
NNO-00320: missing server name parameter
ORA-00280: change string for thread string is in sequence #string
LSX-00121: value is not valid restriction of parent's length
Recent I have migrated oracle9i to oracle10g(10.2.0.3). I have nested table that table used user define datatype. at a column. when i want to input the valoue at this column ,i cann't the input value.following the error messasge i have got: ORA-24328 illegal attribute value
ORA-30336: no child for specified JOIN KEY
RMAN-06509: only SPFILE or controlfile can be restored from autobackup
TNS-12609: TNS: Receive timeout occurred
LSX-00234: invalid decimal "~S"
ORA-26017: global indexes not allowed for direct path load of table partition string
RMAN-06435: recovery catalog owner is string
ORA-13760: duplicate entry for "SQL_ID" "string" in "SQL Tuning Set" "string"