PCC-02344: Host variable array size mismatch. Using minimum: number
SELECT DISTINCT
a,b,c INTO
:v_a,v_b,v_c
编译的时候会报上面的错误
PCC-02344: Host variable array size mismatch. Using minimum: number
google:
the error indicates that NOT all the elements in an array have the same number of rows. Make sure that ALL the elements in an array have same number of rows
Host variable array size mismatch. Using minimum: number
Host variable arrays in a single statement should all be of equal size.
Redefine the bind variable array lengths to all be the same size.
翻译成中国话:(个人理解)
你的查询结果中,返回的各个行数不一致, 也就是a 元素返回10行,b元素返回了8行,c元素返回了4行
个人处理方法:
1. 忽略吧
编译的时候是警告信息,可以在编译的时候不检查sql, 或者报错直接忽略
2. nvl(a,'')
加上nvl 处理一下
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21634752/viewspace-702192/,如需转载,请注明出处,否则将追究法律责任。