Hi Folks,
i have been facing some problem while updating the data into the DB by invoking the stored procedure. Error messages is as follows.

[ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service GovtComplianceSybJdbcAdapterNoTran.Adapters:UpdateGovtComplianceDblglItmCooHaz.
[ADA.1.316] Cannot execute the SQL statement “{call dblgl.dbo.db_dblgl_ldcoohaz (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }”. "
(ZZZZZ/249) Syntax error during explicit conversion of CHAR value 'IN ’ to a DATE field.
"
Syntax error during explicit conversion of CHAR value 'IN ’ to a DATE field.

By looking at the error message, it is clear that it was throwing the error while doing the date conversion. But when i ran the Stored Procedure manually by giving the input values, table is updated successfully. Is there any problem while passing these values to the SP…?

Here is the set up that we did for our Stored Procedure…

we did mention the input parameter as CHAR for the variable update_dt and the input type is defined as java.lang.String. I have processed the transaction by changing the parameter as Date, but no use.

Can anyone please help me regarding this…?

Thanks
Vasu

If the type in DB is Date, on the parameter page:
on top, use the JDBC Type = Date
in the middle, input Type = java.lang.String
HTH,
Tong