也没有少东西,我重新将这些sql语句按照原来的写一遍以后,不再出现这个错误。但是问题是我现在有几千行sql,
求高手指教,这是什么问题
5 个解决方案
#1
求高手赐教。。。。。。。。。。。。。。。
#2
什么都没有
#3
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 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
错误
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
错误
#4
ant脚本自身编码的原因吧。
#5
难道是/要转义么,试试换成//行不行,记得ant里/跟java一样要转义
#1
求高手赐教。。。。。。。。。。。。。。。
#2
什么都没有
#3
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 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
错误
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
错误
#4
ant脚本自身编码的原因吧。
#5
难道是/要转义么,试试换成//行不行,记得ant里/跟java一样要转义