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 |
RMAN-06028: duplicate operand specified in restore specification: string
RMAN-06542: file string is excluded from whole database backup
RMAN-06526: KEEP option cannot be used with incremental backup
ORA-02276: default value type incompatible with column type
ORA-00227: corrupt block detected in controlfile: (block string, # blocks string)
ORA-01272: REUSE only allowed when a file name is provided.
DRG-11533: improper value of column string
NNL-00895: Requests refused, processing disabled: number
ORA-26714: User error encountered while applying
ORA-30023: Duplicate undo tablespace specification
ORA-24070: cannot upgrade queue table string while it is being downgraded
LFI-01510: fread() failed(OSD return value = string) in string.