无网络连接
  1. Home
  2. General

Automation - Update DB Using Extracted Fields fails - Oracle error

作者:Andrew James @andrewjames
    2023-02-21 14:40:55.498Z2023-02-21 15:00:16.859Z

    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

    • 0 回复