Calling XDO Data Engine... --SQLException java.sql.SQLSyntaxErrorException: ORA-00911: invalid chara
Hi All,
Please help the below issue found in XML publisher.
XXTECPAYRPT module: Technosoft Payment Report +---------------------------------------------------------------------------+ Current system time is 03-JAN-2017 19:36:39 +---------------------------------------------------------------------------+ XDO Data Engine Version No: 5.6.3 Resp: 50640 Org ID : null Request ID: 2911615 All Parameters: P_FROM_DATE="2016/01/01 00:00:00":P_TO_DATE="2016/12/31 00:00:00":P_ORG_ID=86 Data Template Code: XXTECPAYRPT Data Template Application Short Name: SQLAP Debug Flag: N {P_TO_DATE=2016/12/31 00:00:00, P_FROM_DATE=2016/01/01 00:00:00, P_ORG_ID=86} Calling XDO Data Engine... --SQLException java.sql.SQLSyntaxErrorException: ORA-00911: invalid character at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1189) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at oracle.apps.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:1947) at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:501) at oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:445) at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:308) at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:273) at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215) at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)