ant脚本运行sql出错,但是sql语句没有任何问题 我用ant写了些sql的脚本,运行时老是出现ORA-00911: invalid character的错误,放在任何地方都没有错。也没有少东西,我重新将这些sql语句按照原来的写一遍以后,不再出现这个错误。但是问题是我现在有几千行sql,求高手指教,这是什么问题 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 INSERT INTO PUB_URLS (URL_CODE, URL_NAME, URL_CONTENT, OPERATION_CODE, FUNCTION_CODE, ACCESS_TYPE, NOTE, SEQ ) VALUES ( '817fe929e841af0129e85142770011', 'sendbulletinlist.jsp', 'jsp/ecgap/inform/sendbulletinlist.jsp', 'sendbulletinlist', 'sendbulletinlist', 'http', '', 0 ); INSERT INTO PUB_URLS (URL_CODE, URL_NAME, URL_CONTENT, OPERATION_CODE, FUNCTION_CODE, ACCESS_TYPE, NOTE, SEQ ) VALUES ( '817fe929e841af0129e852879f0012', 'newwork.jsp', 'jsp/ecgap/exportalreq/newwork.jsp?StartType=HallReceive', 'newwork', 'newwork', 'http', '', 0 ); INSERT INTO PUB_URLS (URL_CODE, URL_NAME, URL_CONTENT, OPERATION_CODE, FUNCTION_CODE, ACCESS_TYPE, NOTE, SEQ ) VALUES ( '817fe929e841af0129e8537be10013', 'exportalreqhall.jsp', 'jsp/ecgap/exportalreq/exportalreqhall.jsp?applysource=Hall', 'exportalreqhall.jsp', 'exportalreqhall.jsp', 'http', '', 0 ); INSERT INTO PUB_URLS (URL_CODE, URL_NAME, URL_CONTENT, OPERATION_CODE, FUNCTION_CODE, ACCESS_TYPE, NOTE, SEQ ) VALUES ( '817fe929e841af0129e8548fa90014', 'messagetypelist.jsp', 'jsp/ecgap/messagecenter/messagetypelist.jsp', 'messagetypelist', 'messagetypelist', 'http', '', 0 ); 语句在pl/sql中执行没有错误,但是用ant执行它所在的文件的时候就报BUILD FAILEDE:\workspace\approval_code\initDatabase.xml:26: The following error occurred while executing this line:E:\workspace\approval_code\initDatabase.xml:214: java.sql.SQLException: ORA-00911: invalid characterTotal time: 2 minutes 2 seconds错误 ant脚本自身编码的原因吧。 难道是/要转义么,试试换成//行不行,记得ant里/跟java一样要转义 请帮我补充 请高手翻译一下,下面的存储过程(sql server版的) oracle 存取blob字段 交叉表的问题 oracle中时间表相减怎么到的具体的间隔? 关于字符集问题 用Oracle Net8 Easy Config时总是不成功? 关于外键的简单问题!!!!!!!!!!!!!!! 菜鸟小脚上路 情大侠们扶一把 谢!!!!!问题小小 大侠请进有分的!!!!:-) VMware server 1.0.6安装时怎么注册 oracle open cursors 问题 请高手指教,急急急,难度相当大
INSERT INTO PUB_URLS (URL_CODE, URL_NAME, URL_CONTENT, OPERATION_CODE, FUNCTION_CODE, ACCESS_TYPE, NOTE, SEQ ) VALUES ( '817fe929e841af0129e852879f0012', 'newwork.jsp', 'jsp/ecgap/exportalreq/newwork.jsp?StartType=HallReceive', 'newwork', 'newwork', 'http', '', 0 );
INSERT INTO PUB_URLS (URL_CODE, URL_NAME, URL_CONTENT, OPERATION_CODE, FUNCTION_CODE, ACCESS_TYPE, NOTE, SEQ ) VALUES ( '817fe929e841af0129e8537be10013', 'exportalreqhall.jsp', 'jsp/ecgap/exportalreq/exportalreqhall.jsp?applysource=Hall', 'exportalreqhall.jsp', 'exportalreqhall.jsp', 'http', '', 0 );
INSERT INTO PUB_URLS (URL_CODE, URL_NAME, URL_CONTENT, OPERATION_CODE, FUNCTION_CODE, ACCESS_TYPE, NOTE, SEQ ) VALUES ( '817fe929e841af0129e8548fa90014', 'messagetypelist.jsp', 'jsp/ecgap/messagecenter/messagetypelist.jsp', 'messagetypelist', 'messagetypelist', 'http', '', 0 );
语句在pl/sql中执行没有错误,但是用ant执行它所在的文件的时候就报BUILD FAILED
E:\workspace\approval_code\initDatabase.xml:26: The following error occurred while executing this line:
E:\workspace\approval_code\initDatabase.xml:214: java.sql.SQLException: ORA-00911: invalid character
Total time: 2 minutes 2 seconds
错误