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

KUP-00562: unknown escape sequence

1 Answers  


ORA-30444: rewrite terminated by the sql analyzer

1 Answers  


RMAN-06436: enter DROP CATALOG command again to confirm catalog removal

1 Answers  


DRG-10800: query failed: string string string

1 Answers  


SQL*Loader-00817: error dropping directory object string

1 Answers  






LSX-00162: string "~S" is an invalid default for the complex type

1 Answers  


LPX-00203: could not read from "~s" (error ~u)

1 Answers  


ORA-12678: Authentication disabled but required

1 Answers  


ORA-29384: number of children for plan string exceeds string

1 Answers  


DRG-10533: invalid user name: string

1 Answers  


PCB-00302: This statement is not supported by ANSI

1 Answers  


DRG-11834: Unsupported Media Type

1 Answers  


Categories