PLS-00359 assignment target in "string" must have components

Translate this page

Oracle Database Error PLS-00359

PLS-00359 assignment target in "string" must have components

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.

User Posts for PLS-00359

Be the first to post a message...

Post your own questions, answers and tips for PLS-00359

No registration required

CAPTCHA Image New word