on 08-03-2010 7:03 AM
Hi Team,
we had a scenario where some tables are getting loaded from MDM to Oracle using PI 7.1, I would like to know the procedure to trigger a Stored Procedure from PI after successful loading of data in to oracle.
Thanks in Advance,
Sriram
Hi,
You can do this on oracle table it self.
Create a trigger (insert/update) on the oracle table and call stored procedure from that for the next action.
Regards,
Praveen Gujjeti
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you need to call or Execute Stored Procedure from PI, so check this Blog :
/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures
Check the statement 5 in this link also for stored procedure
http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
First run the statements as you need to update in table (INSERT or DELETE).
After that run next statement in Mapping for execute Stored Procedure.
Hi,
In this case i think need to go for BPM...
receive the source data and convert and insert into the database using BPM steps..
receive - transform - send.. then call transform and send...
for triggering the stored procedure..
here you need to design the exception blocks for handling failure cases ...
It just a idea for proceeding furhter..
HTH
Rajesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.