Execute Oracle 'before' and 'after' DDL statements

NigeGriff · Post by **NigeGriff** » Thu Sep 03, 2009 10:23 am

Is their an equivalent feature to the server oracle stage 'before and 'after' SQL options in an oracle stage in enterprise.

if not what is the next best alternative.

DSguru2B · Post by **DSguru2B** » Thu Sep 03, 2009 10:29 am

Have you tried looking into the OPEN and CLOSE statements?

Sreenivasulu · Post by **Sreenivasulu** » Fri Sep 04, 2009 1:59 am

'Open' and 'Close' command in PX are the equivalent of 'before sql' and 'after sql' in server. They open a new transaction though..

Regards
Sreeni

vmcburney · Post by **vmcburney** » Sun Sep 06, 2009 9:43 pm

This is harder to do in Oracle Enterprise stage than in the dynamic relational or API stage. You only get Open and Close options if you choose the bulk load/Write method. You don't get them if you try an upsert. As far as I know there is no way to access before/after SQL functionality if you are performing enterprise stage upserts (insert, update or delete). This might be different if you use the new Oracle Enterprise Stage that was released in June.