0 Replies Latest reply on May 7, 2010 9:23 AM by Ankurbindal-Oracle

    java.sql.SQLException: ORA-00911: invalid character

    Ankurbindal-Oracle
      Hi All,

      I have a create page. This create page is an EO based.
      When ever i try to fill up the values on the pages and click on apply, the insert fails. It errors out with the following error:
      java.sql.SQLException: ORA-00911: invalid character

      The statement for insert prepared by EO also seems to be correct, which got printed in the log as below:
      10/05/07 14:47:42 [985] INSERT INTO XXOD_TBL_MPC_SCHEDULE(SEQUENCE_ID,TEMPLATE_NAME,MPC_TYPE,NAME,FREQUENCY,START_DATE,START_TIME,END_TIME,HOLD,DISABLE,WORK_DAY,RESPONSIBILITY_NAME,RESPONSIBILITY_ID,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATED_BY_NAME,LAST_UPDATE_LOGIN,CREATED_BY,CREATION_DATE,DAYS_SPECIFIC,SPECIFIC_FREQUENCY,SPECIFIC_TIMINGS,CONTINIOUS_FLAG) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
      10/05/07 14:47:42 [986] Insert binding param 1: 321
      10/05/07 14:47:42 [987] Insert binding param 2: AP_AW_XWD-1_2130
      10/05/07 14:47:42 [988] Insert binding param 3: Concurrent Program
      10/05/07 14:47:42 [989] Insert binding param 4: CEMLI Performance Checker
      10/05/07 14:47:42 [990] Insert binding param 5: Work Day
      10/05/07 14:47:42 [991] Insert binding param 6: 2009-11-18
      10/05/07 14:47:42 [992] Insert binding param 7: 21:30:00
      10/05/07 14:47:42 [993] Insert binding param 8: 23:59:59
      10/05/07 14:47:42 [994] Insert binding param 9: N
      10/05/07 14:47:42 [995] Insert binding param 10: N
      10/05/07 14:47:42 [996] Insert binding param 11: N
      10/05/07 14:47:42 [997] Insert binding param 12: Application Developer
      10/05/07 14:47:42 [998] Insert binding param 13: 20419
      10/05/07 14:47:42 [999] Insert binding param 14: 2010-05-07
      10/05/07 14:47:42 [1000] Insert binding param 15: 0
      10/05/07 14:47:42 [1001] Insert binding param 16: SYSADMIN
      10/05/07 14:47:42 [1002] Insert binding param 17: 9636010
      10/05/07 14:47:42 [1003] Insert binding param 18: 0
      10/05/07 14:47:42 [1004] Insert binding param 19: 2010-05-07
      10/05/07 14:47:42 [1005] Insert binding param 20: :EL1
      10/05/07 14:47:42 [1006] Insert binding param 21: Once
      10/05/07 14:47:42 [1007] Insert binding param 22: N
      10/05/07 14:47:42 [1008] Insert binding param 23: N
      10/05/07 14:47:42 [1009] OracleSQLBuilderImpl.doEntityDML failed...
      10/05/07 14:47:42 [1010] X/Open SQL State is: 42000




      And the error which came is as:
      10/05/07 14:47:42 [1011] java.sql.SQLException: ORA-00911: invalid character

           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
           at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
           at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
           at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:633)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1161)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
           at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3074)
           at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:427)
           at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:5738)
           at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4537)
           at oracle.apps.fnd.framework.server.OAEntityImpl.postChanges(Unknown Source)
           at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:2996)
           at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2807)
           at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:1971)
           at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2173)
           at oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(Unknown Source)
           at xxod.oracle.apps.xxod.scheduler.schedulejob.server.ScheduleJobAMImpl.createJobSchedule(ScheduleJobAMImpl.java:132)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)




      Please let me know where can be the problem...