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

PLS-01904: : NULL index table key value

1 Answers  


ORA-32734: Error occurred when sending Oradebug command to remote DIAGs

1 Answers  


ORA-29523: authorization error for unknown referenced name

1 Answers  


ORA-06437: ssaio: the asynchronous write was unable to write to the database file.

1 Answers  


ORA-32303: mviews with user-defined types cannot reference multiple master sites

1 Answers  






ORA-15075: disk(s) are not visible cluster-wide

2 Answers  


IMP-00091: Above error occurred on the following function and object: string. Remaining PL/SQL blocks for this object will be skipped.

1 Answers  


ORA-25196: keyword MOVE in ALTER TABLE MOVE must immediately follow <table name>

1 Answers  


ORA-10562: Error occurred while applying redo to data block (file# string, block# string)

1 Answers  


NZE-28840: Wallet is already open.

1 Answers  


ORA-00080: invalid global area specified by level string

1 Answers  


ORA-12817: parallel query option must be enabled

1 Answers  


Categories