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-21704: cannot terminate cache or connection without flushing first
ORA-12488: maximum label does not dominate minimum label
ORA-13621: The task_or object string is marked as a template and cannot perform the requested operation.
ORA-01506: missing or illegal database name
ORA-01608: cannot bring rollback segment 'string' online, its status is (string)
PLS-00732: Illegal overload of ellipsis in formal parameter list
ORA-37117: olapi history retention has been disabled
ORA-36179: (XSNOAGM) No AGGMAP was specified for VARIABLE workspace object.
ORA-02169: FREELISTS storage option not allowed
AUD-00806: first argument to SpeechContains must be a column
ORA-07457: cannot set _INTERNAL_RESOURCE_MANAGER_PLAN because of FORCE
ORA-06255: NETNTT: cannot read pid of remote process