PLS-00570: different number of columns in the multiset and
cast expressions



PLS-00570: different number of columns in the multiset and cast expressions..

Answer / guest

Cause: Number of columns in the collection returned by
MULTISET and the number of columns for the CAST type don't
match. For example: create type tab_obj as object (n
number); create type tab1 as table of tab_obj; create table
tab2 (col1 number, col2 number); select CAST(MULTISET(select
col1, col2 from tab2) as tab1) from tab2;

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-04022: nowait requested, but had to wait to lock dictionary object

2 Answers   Oracle,


ORA-00703: maximum number of row cache instance locks exceeded

1 Answers  


NNL-00413: Total response time: string

1 Answers  


ORA-01942: IDENTIFIED BY and EXTERNALLY cannot both be specified

1 Answers  


NZE-29119: Cannot import certificate.

1 Answers  






ORA-02299: cannot validate (string.string) - duplicate keys found

2 Answers  


NNL-00006: timeout, server is not responding

1 Answers  


ORA-28601: invalid [no]MINIMIZE option

1 Answers  


ORA-38310: cannot purge tablespace for other users

1 Answers  


ORA-00200: controlfile could not be created

1 Answers  


NNF-00002: Invalid value passed to function call

1 Answers  


ORA-02001: user SYS is not permitted to create indexes with freelist groups

1 Answers  


Categories