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-28235: algorithm not available

1 Answers  


ORA-16187: LOG_ARCHIVE_CONFIG contains duplicate, conflicting or invalid attributes

1 Answers  


LPX-00273: failed to initialize TCP/IP

1 Answers  


ORA-01059: parse expected before a bind or execute

1 Answers  


RMAN-01008: the bad identifier was: string

1 Answers  


KUP-04017: OS message: string

1 Answers  


ORA-29917: cannot lock a table which gets its rows from a collection operand

1 Answers  


ORA-16168: LGWR network server could not switch to blocking mode

1 Answers  


NNL-00807: Queries received, type SOA: number

1 Answers  


ORA-27083: waiting for async I/Os failed

1 Answers  


ORA-01506: missing or illegal database name

1 Answers  


ORA-14298: LOB column block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

1 Answers  


Categories