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

QSM-02068: relation is not a partitioned table

1 Answers  


ORA-24162: name value pair list is full, cannot add another entry

1 Answers  


IMG-00515: incorrect number of input channels

1 Answers  


PLS-00522: MAP methods must return a scalar type.

1 Answers  


ORA-16612: string value too long for attribute "string"

1 Answers  


CLSR-00528: RACGONS: host and port number already configured in OCR

1 Answers  


ORA-36676: (XSDPART14) Missing dimension list for string.

1 Answers  


DRG-50943: query token too long on line string on column string

1 Answers  


ORA-09367: Windows 3.1 Two-Task driver unable to deallocate shared memory

1 Answers  


DRG-11427: valid gist level values are string

1 Answers  


ORA-31687: error creating worker process string with worker id string

1 Answers  


NNL-00404: TTL: string

1 Answers  


Categories