cancel
Showing results for 
Search instead for 
Did you mean: 

how to trigger a stored procedure from PI after loading data into Oracle

sriram_devarapalli
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member181985
Active Contributor
0 Kudos

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

sriram_devarapalli
Participant
0 Kudos

Hi Team,

Thanks for the response,

Can we schedule to trigger a Stored Procedure at 4:00 AM every day with out any sender Communication channel.

Thanks in Advance.

Sriram

former_member208856
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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