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

ORA-30931: Element 'string' cannot contain mixed text

1 Answers  


ORA-01417: a table may be outer joined to at most one other table

1 Answers  


RMAN-10011: synchronization error while polling for rpc number, action=string

1 Answers  


RMAN-05006: cannot recover clone standby single tablespaces

1 Answers  


ORA-38496: Expression Filter index is not in a valid state

1 Answers  






ORA-25133: duplicate SINGLE TABLE option specified

1 Answers  


ORA-00126: connection refused; invalid duplicity

1 Answers  


QSM-00765: cannot validate user-defined workload because table string.string is invalid.

1 Answers  


ORA-25199: partitioning key of a index-organized table must be a subset of the primary key

1 Answers  


ORA-24332: invalid object type

1 Answers  


TNS-00556: no method specified for wallet retrieval

1 Answers  


ORA-12016: materialized view does not include all primary key columns

1 Answers  


Categories