Issue while trying to update using ATP adapter using the option "Run Sql Statement"
Summary:
Unable to use update query in Run Sql Statement option under ATP adapter
Content (please ensure you mask any confidential information):
I selected the Run Sql Statement option and added the below update query
update XXSOL_ORD_CKPIT_HDR_STG set REQUESTED_SHIP_DATE= #pdate where record_id= #p_rec_id
Though values get assigned, It causes below error.
Pure SQL Exception.\nPure SQL Execute of update XXSOL_ORD_CKPIT_HDR_STG set REQUESTED_SHIP_DATE= ? where record_id= ? failed.\nCaused by Exception [EclipseLink-3001] (Eclipse Persistence Services - 2.6.7.v20230512-ce26847): org.eclipse.persistence.exceptions.ConversionException\nException Description: The object [18-APR-24], of class [class java.lang.String], could not be converted to [class java.sql.Timestamp].\nInternal Exception: BINDING.JCA-11635\nCould Not Convert Date Exception.\nUnable to convert a string value in the xml to a java.sql.Date.\nEven though databases accept strings representing dates in a variety of formats, the adapter only accepts strings representing dates in xml ISO date format.\nThe input value must be in the iso 8601 date format YYYY-MM-DD.\n.\nCheck to ensure that the database object(table,view) exists and all