Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-16008: indeterminate control file checkpoint

1 Answers  


NNO-00320: missing server name parameter

1 Answers  


ORA-00280: change string for thread string is in sequence #string

1 Answers  


LSX-00121: value is not valid restriction of parent's length

1 Answers  


Recent I have migrated oracle9i to oracle10g(10.2.0.3). I have nested table that table used user define datatype. at a column. when i want to input the valoue at this column ,i cann't the input value.following the error messasge i have got: ORA-24328 illegal attribute value

1 Answers  


ORA-30336: no child for specified JOIN KEY

1 Answers  


RMAN-06509: only SPFILE or controlfile can be restored from autobackup

1 Answers  


TNS-12609: TNS: Receive timeout occurred

1 Answers  


LSX-00234: invalid decimal "~S"

1 Answers  


ORA-26017: global indexes not allowed for direct path load of table partition string

1 Answers  


RMAN-06435: recovery catalog owner is string

1 Answers  


ORA-13760: duplicate entry for "SQL_ID" "string" in "SQL Tuning Set" "string"

1 Answers  


Categories