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 |
ORA-19684: block media recovery failed because database is suspended
ORA-26021: index string.string partition string loaded successfully with string keys
ORA-29518: name string resolved to an object in schema string that is not a Java class
ORA-17611: ksfd: file 'string' cannot be accessed, global open closed
NNO-00110: line string: unknown data type "string", data ignored
ORA-03235: max # extents (string) reached in table string.string subpartition string
ORA-35095: (QFSVNS01) One or more imported values of fixed-width dimension workspace object have been truncated.
KUP-04077: unknown format specifier in file name string
ORA-26678: Streams capture process must be created first
ORA-13601 encountered when generating server alert SMG-3503
EXP-00034: error on rowid: file# number block# number slot# number
ORA-06033: NETDNT: connect failed, partner rejected connection