Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-28221: REPLACE not specified

1 Answers  


PLS-00246: PARAMETER STYLE is unsupported

1 Answers  


RMAN-06003: ORACLE error from target database: string

1 Answers  


ORA-01634: rollback segment number 'string' is about to go offline

1 Answers  


ORA-19633: controlfile record string is out of sync with recovery catalog

1 Answers  






ORA-13784: cannot accept SQL profiles for all statements in the "SQL Tuning Set"

1 Answers  


ORA-40004: penalty must be negative for BLAST-N

1 Answers  


ORA-38747: corrupt before image (file# string, block# string)

1 Answers  


ORA-06109: NETTCP: message receive failure

1 Answers  


ORA-06973: X.25 Driver: invalid buffer size

1 Answers  


ORA-38734: Flashback log is inconsistent; belongs to another database.

1 Answers  


DRG-52101: an invalid session handle was passed to Oracle Text

1 Answers  






Categories