Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Receiver JDBC Date format error.

We have scenario with JDBC receiver channel. The date format which is being passed is DD/MM/YYYY HH:MM:SS. It throws the exception ORA-01843: not a valid month on receiver end. On receiver end the insert command works with to_date conversion function.

Is there any way to use the to_date function in XI or else how do we resolve this.

Is it possible to see the sql string (after converion from XML) which is being issued to target ( JDBC) end.

Any pointer will be great help

replied

DATE/TIME datatypes and Oracle Database

For seeing the SQL query,

JDBC Receiver Adapter Parameters - Additional Parameter

Parameter name: "logSQLStatement"

Parameter type: boolean

Parameter value: true for any string value, false only for empty string

Parameter value default: false (empty String)

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question