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-30931: Element 'string' cannot contain mixed text
ORA-01417: a table may be outer joined to at most one other table
RMAN-10011: synchronization error while polling for rpc number, action=string
RMAN-05006: cannot recover clone standby single tablespaces
ORA-38496: Expression Filter index is not in a valid state
ORA-25133: duplicate SINGLE TABLE option specified
ORA-00126: connection refused; invalid duplicity
QSM-00765: cannot validate user-defined workload because table string.string is invalid.
ORA-25199: partitioning key of a index-organized table must be a subset of the primary key
ORA-24332: invalid object type
TNS-00556: no method specified for wallet retrieval
ORA-12016: materialized view does not include all primary key columns