PLS-00403: expression 'string' cannot be used as an
INTO-target of a SELECT/FETCH statement



PLS-00403: expression 'string' cannot be used as an INTO-target of a SELECT/FETCH stateme..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-30478: Specified dimension does not exist

1 Answers  


SQL*Loader-00291: Invalid bind variable string in SQL string for column string.

1 Answers  


ORA-06440: ssaio: the asynchronous read returned incorrect number of bytes

1 Answers  


ORA-00720: ALTER DATABASE RESET COMPATIBILITY command has been de-supported

1 Answers  


ORA-21560: argument string is null, invalid, or out of range

1 Answers  






ORA-32143: Environment not specified

1 Answers  


ORA-30683: failure establishing connection to debugger

1 Answers  


ORA-23453: requested operation is not supported on top flavor

1 Answers  


AMD-00160: Warning! Exceeded maximum Custom Measure number of "string"

1 Answers  


ORA-21701: attempt to flush objects to different servers

1 Answers  


ORA-19640: datafile checkpoint is SCN string time string

1 Answers  


ORA-33078: (XSAGDNGL39) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must refer to a dimension.

1 Answers  


Categories