2080501 - ORA-00936: missing expression error in PI JDBC Adapter

• The Process Integration (PI) JDBC Receiver adapter operation (e.g. Insert, Update etc) does not reach the target Oracle database
• An error similar to below is visible in the Log Viewer and/or defaultTrace files:
  
  Exception caught when executing statement for table/stored proc. '<DatabaseTableName>' (structure 'INSERT_AP1228'):
  java.sql.SQLException: ORA-00936: missing expression
  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:745)
  #at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
  #at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961)
  #at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
  #at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1657)
  #at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1626)
  #at com.sap.aii.adapter.jdbc.SAXHandler.executeUpdate(xml2sql.java:2396)
  #at com.sap.aii.adapter.jdbc.SAXHandler.SQLins(xml2sql.java:2130)
  #at com.sap.aii.adapter.jdbc.SAXHandler.processList(xml2sql.java:822)
  #at com.sap.aii.adapter.jdbc.SAXHandler.endElement(xml2sql.java:708)....
  
  ...TextKey=JDBC_ERR_403
  
  

• PI Release Independent
• SAP NetWeaver
• SAP Process Integration
• Kernel Release 7.20 and higher

Process Integration 7.0, PI 7.0, PI 7.01, PI 7.02, Process Integration 7.10, PI 7.10, Process Integration 7.11, PI 7.11, Process Integration 7.30, PI 7.30, Process Integration 7.31, PI 7.31, Process Orchestration 7.4, PI 7.4, PO 7.4, Process Orchestration 7.5, PI 7.5, PO 7.5, XI, AEX, enhancement pack, Oracle 11g , KBA , BC-XI-CON-JDB , JDBC Adapter , Problem