Had an Automation Script that worked fine in prior version. First time running after last major upgrade it did not work and I’ve just avoided researching (or posting) by just running the native sql that the *.tas doesn’t like.
the TAS has three pieces. Import + SQL script + SQL script. Import works file. Dies upon executing first SQL script. I can run exact SQL in the editor and it works fine.
“Execution Error: ORA-00900: invalid SQL statement”
It’s an INSERT statement.
I’ve tried rebuilding the template section many times in various ways (entering sql, referring to sql file etc.) to no avail.
added and removed COMMIT from the SQL too and neither version worked.
Here’s the SQL, but as I said this works in the editor:
INSERT INTO vaggrd.vagg_deleted_product_impact
WHERE CK_DELETE_IMPACT_ADD.STATUS <> ‘OLD’);