Bonjour à tous, j'ai une requete SQL,

en la lançant de TOAD pas de souci mais en lançant la meme de JDBC,
j'ai l'erreur suivante :

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
DEBUG 3 2010040000000069 10/06/2010
 
Jun 11, 2010 3:04:45 PM com.cge.tt.TTCommons.ORDERDataAccess.DunningDAO UpdateBillCancelStatus
 
INFO: Begin : Update Bill Cancel Status
 
Jun 11, 2010 3:04:45 PM com.cge.tt.TTCommons.ORDERDataAccess.DunningDAO UpdateBillCancelStatus
 
INFO: Query Update Bill Cancel Status:  INSERT INTO DUNNING_CANCELLED_BILLS_ALL (STEP_ID, OHXACT,CANCEL_DATE,USER_LAST_MOD, ENT_DATE, REASON_ID,ACTEL_ID) val
 
ues (4,15182280,SYSDATE,null,SYSDATE,null,null);
 
java.sql.SQLException: ORA-00911: invalid character
 
 
 
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
 
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
 
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
 
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
 
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
 
        at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
 
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
 
        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1272)
 
        at com.cge.tt.TTCommons.ORDERDataAccess.DunningDAO.UpdateBillCancelStatus(Unknown Source)
 
        at com.cge.tt.TTDunningListeRelanceSU.TTDunningListeRelancePageController.processPage(Unknown Source)
 
        at com.lhs.ccb.cfw.wcs.solutionunit.AbstractPageController.getResult(Unknown Source)
 
        at com.lhs.ccb.cfw.wcs.solutionunit.AbstractSolutionUnitController.handleRequest(Unknown Source)
 
        at com.lhs.ccb.cfw.wcs.solutionunit.SolutionUnitServlet.handleWorkflowRequest(Unknown Source)
 
        at com.lhs.ccb.cfw.wcs.solutionunit.SolutionUnitServlet.doGet(Unknown Source)
 
        at com.lhs.ccb.cfw.wcs.solutionunit.SolutionUnitServlet.doPost(Unknown Source)
 
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
 
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
 
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
 
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
 
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
 
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
 
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
 
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
 
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
 
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
 
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)