执行SQL报ORA-03113: end-of-file on communication channel错误，各位大侠，请帮忙看看！

[Cango]

SQL1:

SELECT * FROM dwb_dbillinfo_arch dbi
WHERE EXISTS (SELECT 1 FROM (
SELECT DISTINCT vb.ID,vb.unittype FROM vtru_bureau vb CONNECT BY PRIOR vb.ID=vb.parentid
START WITH instrb(';'||120001060||';' , ';'||vb.ID||';')>0 ) t
WHERE t.unittype='B' AND t.ID=dbi.bureauid)

SQL2:

SELECT * FROM dwb_dbillinfo_arch dbi
WHERE ('120001060' IS NULL OR dbi.bureauid IN (SELECT ID FROM (
SELECT DISTINCT vb.ID,vb.unittype FROM vtru_bureau vb CONNECT BY PRIOR vb.ID=vb.parentid
START WITH instrb(';'||120001060||';' , ';'||vb.ID||';')>0 ) t
WHERE t.unittype='B'))

SQL3：

SELECT * FROM dwb_dbillinfo_arch dbi
WHERE dbi.bureauid IN (SELECT ID FROM (
SELECT DISTINCT vb.ID,vb.unittype FROM vtru_bureau vb CONNECT BY PRIOR vb.ID=vb.parentid
START WITH instrb(';'||120001060||';' , ';'||vb.ID||';')>0 ) t
WHERE t.unittype='B')

上面的SQL1和SQL2执行时报如标题据说的错误,SQL3执行却没问题。
各位大侠，帮忙看看。

[liuyi8903]

那一般来说就是语句的问题了.仔细检查一下吧.