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-13425: function not implemented

1 Answers  


TNS-01203: Missing the account (string) specified by DEFAULT_USER_ACCOUNT in SID_DESC

1 Answers  


ORA-38479: creation of system trigger EXPFIL_RESTRICT_TYPEEVOLVE failed

1 Answers  


NNL-00953: Cache lookup exact matches: number

1 Answers  


DRG-11439: index name length exceeds maximum of string bytes

1 Answers  






ORA-32334: cannot create prebuilt materialized view on a table already referenced by a MV

1 Answers  


ORA-29760: instance_number parameter not specified

1 Answers  


KUP-04004: error while reading file string

1 Answers  


ORA-06579: Bind variable not big enough to hold the output value

1 Answers  


PCC-00080: TYPE identifier already TYPEd

1 Answers  


ORA-08455: syntax error in CURRENCY SIGN environment clause

1 Answers  


TNS-04063: Remote administration disabled in the Oracle Connection Manager instance.

1 Answers  


Categories