We are using a JDBC Receiver adapter to insert data into Oracle. The data is being passed as XML SQL format.
xml node is
<LOGDATE>23-FEB-2009</LOGDATE>
Oracle column LOGDATE is a DATE column
The insert was successful in PI 7.0 and PI 7.1 until we upgraded the OS to Solaris 10. We know get the following error:
ORA-01858: a non-numeric character was found where a numeric was
expected
We can successfully insert the string '23-FEB-2009' into the Oracle Date column using SQL Plus. Using PI we can successfully insert if we change the string to '23-FEB-09'. We would prefer to change a setting in Solaris or PI so PI will accept '23-FEB-2009' rather than chaning all of our code to use '23-FEB-09'. We can also successfully use the Oracle TO_DATE function in the PI message, but that couples the message to Oracle and also requires a lot of code changes.
Thanks,
Dave