In the Database definition file for Oracle, I've added a number of items , which will cause XML wrappers to appear in SQL generated from a PDM. Most of these work as expected, with the exception of
"Script \ Objects \ Table \ AfterModify"
This statement ALWAYS appears immediately after the statement output from BeforeModify, and therefore before the 'alter table' statement that it's meant to follow. Very annoying.
Am I the only one that suffers from this?
I've also tried using AlterTableHeader and AlterTableFooter, but they don't appear at all.
My DBMS is Oracle 12c.
Thanks to Arnaud from SAP, I know the following:
* Table.AfterModify is only triggered by a subset of 'modify' events, such as an ALTER statement to add a column
* In the SQL PD generated, the Table.AfterModify item appears immediately after the able.BeforeModify item; I assumed it had been generated too early, but I was wrong - I now think that PD wrongly outputs the pair of items sometimes.
See KBA 2404558 - https://launchpad.support.sap.com/#/notes/2404558