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 |
KUP-00562: unknown escape sequence
ORA-30444: rewrite terminated by the sql analyzer
RMAN-06436: enter DROP CATALOG command again to confirm catalog removal
DRG-10800: query failed: string string string
SQL*Loader-00817: error dropping directory object string
LSX-00162: string "~S" is an invalid default for the complex type
LPX-00203: could not read from "~s" (error ~u)
ORA-12678: Authentication disabled but required
ORA-29384: number of children for plan string exceeds string
DRG-10533: invalid user name: string
PCB-00302: This statement is not supported by ANSI
DRG-11834: Unsupported Media Type