PLS-00359: assignment target in 'string' must have components



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

Post New Answer

More Oracle Errors Interview Questions

RMAN-06028: duplicate operand specified in restore specification: string

1 Answers  


RMAN-06542: file string is excluded from whole database backup

1 Answers  


RMAN-06526: KEEP option cannot be used with incremental backup

1 Answers  


ORA-02276: default value type incompatible with column type

1 Answers  


ORA-00227: corrupt block detected in controlfile: (block string, # blocks string)

1 Answers  






ORA-01272: REUSE only allowed when a file name is provided.

1 Answers  


DRG-11533: improper value of column string

1 Answers  


NNL-00895: Requests refused, processing disabled: number

1 Answers  


ORA-26714: User error encountered while applying

3 Answers  


ORA-30023: Duplicate undo tablespace specification

1 Answers  


ORA-24070: cannot upgrade queue table string while it is being downgraded

1 Answers  


LFI-01510: fread() failed(OSD return value = string) in string.

1 Answers  


Categories