DML Sql query running fine in TOAD but unable to run in UIPATH

recently database is migrated to OCI. DML Sql query running fine in TOAD but unable to run in UiPath. looks type cast error could you please suggest on this.

Can you share error details, what error are you getting when you run the qiery from UiPath?

Error] Execute Query: ORA-01858: a non-numeric character was found where a numeric was expected

ORA-06512: at “CUOWN.OEORDER_RELEASE_AUR”, line 542

ORA-04088: error during execution of trigger ‘CUOWN.OEORDER_RELEASE_AUR’

ORA-06512: at line 1

Hey,
Apologies for the delay in response.

Could you put your query here if possible, seems like an extra or missing character ( could be double quote " or single quote ').

Also pick up your query from local panel and try to run the same in TOAD if it runs fine?