Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-23379: connection qualifier "string" is too long

1 Answers  


ORA-33338: (DSSEXIST05) You cannot specify the EXPTEMP analytic workspace.

1 Answers  


ORA-23385: replication parallel push string argument not valid

1 Answers  


ORA-02024: database link not found

1 Answers  


NNL-00235: Auto-refresh failure-retry expiration period is now string

1 Answers  






ORA-01772: Must specify a value for LEVEL

1 Answers  


ORA-07281: slsget: times error, unable to get cpu time.

1 Answers  


ORA-15133: instance recovery required for diskgroup string

1 Answers  


QSM-00753: the specified value string is out of the acceptable range of string to string for parameter string

1 Answers  


ORA-26695: error on call to string: return code string

1 Answers  


RMAN-08119: skipping backup piece handle string; already exists

1 Answers  


ORA-06777: TLI Driver: error reading parms

1 Answers  






Categories