Symptom
In a system using an Oracle database, multiple pre-SQL execution actions or post-SQL execution actions may fail in DataExchange.
1) Verify that each pre-SQL execution action or post-SQL execution action is set up individually, rather than combined into one.
2) For each execution action, remove any semicolons (;).
3) For each execution action, verify that any COMMIT statements are removed.
Oracle (All versions)
Resolution
To resolve this issue, follow the steps below.1) Verify that each pre-SQL execution action or post-SQL execution action is set up individually, rather than combined into one.
2) For each execution action, remove any semicolons (;).
3) For each execution action, verify that any COMMIT statements are removed.
Applies To
OnGuard (All versions)Oracle (All versions)
