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-00359: assignment target in 'string' must have components



PLS-00359: assignment target in 'string' must have components..

Answer / guest

Cause: An assignment target was declared that lacks the
components needed to store the assigned values. For example,
this error occurs if you try to assign a row of column
values to a variable instead of a record, as follows:
DECLARE dept_rec dept%ROWTYPE; my_deptno dept.deptno%TYPE;
... BEGIN SELECT deptno, dname, loc INTO my_deptno --
invalid FROM dept WHERE ...

Action: Check the spelling of the names of the assignment
target and all its components. Make sure the assignment
target is declared with the required components and that the
declaration is placed correctly in the block structure.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-25407: connection terminated

1 Answers  


DRG-12305: column string data type is not supported for index set columns

1 Answers  


TNS-12219: TNS:missing community name from address in ADDRESS_LIST

1 Answers  


ORA-24015: cannot create QUEUE_TABLE, QUEUE_PAYLOAD_TYPE string.string does not exist

1 Answers  


PLS-00241: invalid external type specification for SQLSTATE

1 Answers  


ORA-02183: valid options: ISOLATION_LEVEL { SERIALIZABLE | READ COMMITTED }

1 Answers  


ORA-16549: invalid string

1 Answers  


ORA-07606: szprv: $CHKPRO failure

1 Answers  


RMAN-08010: channel string: specifying datafile(s) in backupset

1 Answers  


IMG-00601: out of memory while copying image

1 Answers  


RMAN-08549: database name (or lock name space) used for search: string

1 Answers  


ORA-22161: type code [string] is not valid

1 Answers  


Categories