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 |
EXP-00013: respond with either 'Y', 'N', RETURN or '.' to quit
ORA-02062: distributed recovery received DBID string, expected string
ORA-28120: driving context already exists
ORA-21612: key is already being used
QSM-02120: compatibility mode must be 9.0 or higher
ORA-24398: connection pool already exists
RMAN-06210: List of Mismatched objects
ORA-37021: (XSMULTI02) Object workspace object is not acquired.
ORA-25117: MIN/MAX/Block Number expected
ORA-39036: invalid metadata filter name string
NNO-00257: warning: cannot get serial number from region store
TNS-01172: Listener has shut down since all listen addresses have been deallocated