JAVA读取文本文件,然后执行该SQL语句,出现java.sql.SQLException: ORA-00911: invalid character报错

[tyfun]

该SQL在SQLPLUS\WORKSHEET里执行没问题
文本文件里的SQL语句如下:

truncate table TRS.tb_affair_appendix;
insert into TRS.tb_affair_appendix(GscApproveDatumSetGuid,GscApproveDatumName,GscApproveDatumFormatCodeId,GscApproveDatumCopies,GscApproveProjectCodeId,flag,dealFlag,files)
select datum.F2,datum.F5,datum.F6,datum.F7,datum.F4,0,0,to_lob(doc.F9)
from GxGscManage."ApproveDatumSet" datum left join GxGscManage.APPDOCFILE_TEMP doc on datum.F8=doc.F3 and doc.F10=0 where doc.AREACODE='1'
order by datum.F1;


truncate table TRS.tb_affair_evidence;
insert into TRS.tb_affair_evidence(GscApproveWarrantySetGuid,GscApproveWarrantyGovDocTitle,GscApproveWarrantyGovDocItem,GscApproveWarrantyGovDocTime,
GscApproveWarrantyGovDocCodeId,GscApproveProjectCodeId,flag,dealFlag)
select F2,F5,F6,F11,
F8,F4,0,0 from GxGscManage."ApproveWarrantySet" where F9='GscObjectStatus_OK' and AREACODE='1'
order by F1;


truncate table TRS.tb_affair_condition;
insert into TRS.tb_affair_condition(GscApproveConditionSetGuid,GscApproveCondition,GscApproveProjectCodeId,flag,dealFlag)
select F2,F5,F4,0,0 from GxGscManage.ApproveConditionSet where
F6='GscObjectStatus_OK' and AREACODE='1'
order by F1;

[rascalboy520]

先看一下你的语句有没有问题，然后打印出来，

[songbeirui]

你看一下你的数据类型,是否一致!

[tyfun]

SQL语句这些没有问题的

[a409693932]

去掉分号;

[tyfun]

[Quote=引用 6 楼 a409693932 的回复:]
去掉分号;
[/Quote]

如果一个文本里有多个语句,怎么样做?JAVA程序会自动识别是多个语句吗?

[tyfun]

[Quote=引用 5 楼 cuilike 的回复:]
;要去掉的吧
[/Quote]


如果一个文本里有多个语句,怎么样做?JAVA程序会自动识别是多个语句吗?

[tyfun]

自己顶

[cuilike]

;要去掉的吧

[tyfun]

自己顶