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-19684: block media recovery failed because database is suspended

1 Answers  


ORA-26021: index string.string partition string loaded successfully with string keys

1 Answers  


ORA-29518: name string resolved to an object in schema string that is not a Java class

1 Answers  


ORA-17611: ksfd: file 'string' cannot be accessed, global open closed

1 Answers  


NNO-00110: line string: unknown data type "string", data ignored

1 Answers  


ORA-03235: max # extents (string) reached in table string.string subpartition string

1 Answers  


ORA-35095: (QFSVNS01) One or more imported values of fixed-width dimension workspace object have been truncated.

1 Answers  


KUP-04077: unknown format specifier in file name string

1 Answers  


ORA-26678: Streams capture process must be created first

1 Answers   Yahoo,


ORA-13601 encountered when generating server alert SMG-3503

0 Answers   DB Experts,


EXP-00034: error on rowid: file# number block# number slot# number

1 Answers  


ORA-06033: NETDNT: connect failed, partner rejected connection

1 Answers  


Categories