How to fix the Oracle error PLS-00359: assignment target in ‘string’ must have components?

In this post, you’ll learn more about the Oracle ErrorPLS-00359: assignment target in ‘string’ must have components with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00359: assignment target in ‘string’ must have components

Reason for the Error PLS-00359: assignment target in ‘string’ must have components

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 …

How to fix the Error PLS-00359: assignment target in ‘string’ must have components ?

You can fix this error in Oracle by following the below steps

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.