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

NNO-00152: warning: hint count number exceeds maximum of number, first number will be loaded

1 Answers  


ORA-02140: invalid tablespace name

1 Answers  


ORA-14052: partition-extended table name syntax is disallowed in this context

1 Answers  


NNO-00106: line string: invalid TTL "string", data ignored

1 Answers  


ORA-24360: Type Descriptor Object not specified for Object Bind/Define

1 Answers  






ORA-31644: unable to position to block number string in dump file "string"

1 Answers  


NCR-00003: NCR: Initialization failure

1 Answers  


ORA-04034: unable to shrink pool to specified size

1 Answers  


NZE-29192: Validation mechanism not set in OID

1 Answers  


RMAN-08088: applied offline range to datafile string

1 Answers  


ORA-16022: LOG_ARCHIVE_DEST cannot be NULL because LOG_ARCHIVE_DUPLEX_DEST is non-NULL

1 Answers  


ORA-16737: The log transport service for standby "string" has an error.

1 Answers  


Categories