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-22899: cannot specify both scope and rowid constraint on ref column

1 Answers  


ORA-39058: current object skipped: string of type string

1 Answers  


ORA-01183: cannot mount database in SHARED mode

1 Answers  


ORA-27064: cannot perform async I/O to file

1 Answers  


TNS-12214: TNS:missing local communities entry in TNSNAV.ORA

1 Answers  






ORA-19666: cannot do incremental restore of the controlfile

1 Answers  


NID-00450: Succesfully changed database name and ID.

1 Answers  


PCB-00639: Cannot specify destination offset in a LOB WRITE APPEND

1 Answers  


ORA-02717: osnpfs: incorrect number of bytes written

1 Answers  


LSX-00282: duplicate notation name "~S"

1 Answers  


LFI-00143: Unable to delete non-existent file string.

1 Answers  


ORA-12013: updatable materialized views must be simple enough to do fast refresh

1 Answers  


Categories