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-21704: cannot terminate cache or connection without flushing first

1 Answers  


ORA-12488: maximum label does not dominate minimum label

1 Answers  


ORA-13621: The task_or object string is marked as a template and cannot perform the requested operation.

1 Answers  


ORA-01506: missing or illegal database name

1 Answers  


ORA-01608: cannot bring rollback segment 'string' online, its status is (string)

1 Answers  


PLS-00732: Illegal overload of ellipsis in formal parameter list

1 Answers  


ORA-37117: olapi history retention has been disabled

1 Answers  


ORA-36179: (XSNOAGM) No AGGMAP was specified for VARIABLE workspace object.

1 Answers  


ORA-02169: FREELISTS storage option not allowed

1 Answers  


AUD-00806: first argument to SpeechContains must be a column

1 Answers  


ORA-07457: cannot set _INTERNAL_RESOURCE_MANAGER_PLAN because of FORCE

1 Answers  


ORA-06255: NETNTT: cannot read pid of remote process

1 Answers  


Categories