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-14083: cannot drop the only partition of a partitioned table
DRG-50943: query token too long on line string on column string
ORA-00285: TIME not given as a string constant
ORA-31039: XML namespace length string exceeds maximum string
DRG-50927: parser failed on line string on column string
ORA-01898: too many precision specifiers
PCB-00204: Group items cannot be used except in INTO or VALUES clause
ORA-13186: fixed tile size tessellation failed
ORA-09701: scnfy: maximum number of processes exceeded
QSM-02118: duplicate grouping sets
ORA-32317: cannot run a job from a job
ORA-19683: real and backup blocksize of file string are unequal