AnsweredAssumed Answered

Calling PMAs in triggers (Oracle) - is it possible?

Question asked by pkrystosiak on Nov 20, 2012
Latest reply on Nov 28, 2012 by Chris_Hackett
Hi all,
I am struggling with an automated addition of a project as a child to another project (in reaction to a change in another object's attribute). The change can be detected in a trigger and this trigger, when fired, could make all the necessary inserts and updates on all the tables like INV_HIERARCHIES, ODF_CA_INVESTMENTHIERARCHY, ODF_CA_INVESTMENTALLOCATION, etc.

But this is sooooo hard!

And the most important - it's has already been done! ALL the SQL queries, conditions, sequence - all the logic is already in XML files (like in %CLARITY_HOME%\META-INF\pma\wmd\investment.xml or %CLARITY_HOME%\META-INF\pma\pmd\investmentsPMD.xml ( in my case).

The question is if it's possible to USE it in a TRIGGER?
And HOW?

It is very easy through the UI -> just a click. What if we could simulate such "a click" ina trigger?

Any ideas?

Best regards,
Pawel

Outcomes