Important: OTM does not support arbitrary SQL syntax in Direct SQL Update actions. Only a specific subset of Oracle SQL formats are accepted — standard INSERT, UPDATE, DELETE statements and simple PL/SQL procedure calls. Complex constructs such as multi-table joins in UPDATE statements, MERGE, CTEs, or anonymous PL/SQL blocks with DECLARE sections are not supported. Always test your SQL in a lower environment before deploying to production, and keep statements as simple as possible.