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-04061: existing state of string has been invalidated

1 Answers  


ORA-09916: Required password was not specified.

1 Answers  


ORA-26712: remote object is "string"."string"\@"string"

1 Answers  


ORA-16084: an apply engine is already running

1 Answers  


ORA-27044: unable to write the header block of file

1 Answers  






ORA-12518: TNS:listener could not hand off client connection

1 Answers  


RMAN-06494: %s = string is out of range (string-string)

1 Answers  


RMAN-08102: channel string: located backup piece: string

1 Answers  


RMAN-08036: channel string: could not create controlfile record for string string

1 Answers  


DRG-11224: Third-party filter is unable to create or write to temporary file.

1 Answers  


QSM-02101: mv references a synonym in the FROM list

1 Answers  


ORA-00064: object is too large to allocate on this O/S (string,string)

1 Answers  


Categories