Automation - Update DB Using Extracted Fields fails - Oracle error
I've been using TA4 for many years and now trying to get TA v5 working for us using some trial triggers. I'm finding a problem with the built in option to "Update DB using extracted fields" to update an Oracle database. Error given in the log is"ORA-00933: SQL command not properly ended From Insert (Error)" but I can't see in the log what the code is actually trying to post to the DB. This is the pre-configured option so I can't amend the SQL, it's just what TA5 has created.
If I use exactly the same SQL and DB connection but using the option "Update DB using Custom SQL" it fails still but if I run without the semicolon at the end then it runs fine and the record is saved to the DB. I can't remove the semicolon from the built in code.
INSERT INTO received_sms (received_date,Mobile_Number,message)
VALUES (@received_date,@Mobile_Number,@message);
Is there an issue with running SQL against an Oracle DB or some parameter I need to set to get the configuration working for Oracle using the built in update automation?
Currently running 5.0.1223.2 studio and server 5.0.912.2
Thanks
Andy