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-22340: cannot string type "string"."string". Dependent tables must be upgraded to latest version

1 Answers  


RMAN-06077: datafile string is a different version than contained in the controlfile

1 Answers  


PCC-00144: UNSAFE_NULL=YES must be used with DBMS=V7 and MODE=ORACLE

1 Answers  


ORA-12413: labels do not belong to the same policy

1 Answers  


ORA-24901: handles belonging to different environments passed into an OCI call

1 Answers  


ORA-00405: compatibility type "string"

1 Answers  


ORA-26056: Can not unload from a view through the direct path.

1 Answers  


DRG-12307: column string is NULL and cannot be indexed

1 Answers  


ORA-14150: missing SUBPARTITION keyword

1 Answers  


ORA-24366: migratable user handle is set in service handle

1 Answers  


ORA-22342: dependent VARRAY column exceeds the maximum inline column size

1 Answers  


ORA-07550: sftopn: $CONNECT failure

1 Answers  


Categories