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

PLS-00570: different number of columns in the multiset and cast expressions
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

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00570：多个集合和转换表达式中的列数不同,
.原因： MULTISET返回的集合中的列数和CAST类型的列数不匹配。例如：create type tab_obj as object（n number）; 创建类型tab1作为tab_obj的表; 创建表tab2（col1号，col2号）; 从tab2中选择CAST（MULTISET（从col2选择col1，col2）作为tab1）;,
.行动：无,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题