Calling Stored Procedure in BPM

[Former Member]

Hi All,

I am trying to call a Stored Procedure in BPM.

I have a scenario in which after JDBC receiver step i want to call a stored procedure which does some manipulation.(Plz note that SP doesn't need any parameters as Input and returns nothing).

Now i have done following steps:

1) Created a datatype with SP name as element and action as attribute having value "Execute".

2) Created Message Type

3) Created Abs Asynch interface

4)Mapping( same message is mapped to itself)

5)In Integration Process created a send step

6)Created a container with abstract interface

7) In Directory created service and channel

😎 Reciver determination with sender service as IP and receiver service

9) Interface determination with sender service as IP n receiver service with receiver channel

10) Receiver agreement with sender service as IP n receiver service with receiver channel.

But Outbound status of my message is sent to be scheduled.

and in message monitoring i can find

"<Trace level="1" type="T">no interface found</Trace> "

Can anybody suggest me is anything wrong in steps?

How should i monitor BPM to know what exactly is going wrong?

Thanks,

Rohan

[Former Member]

Rohan,

I have found the following blogs useful. They will reinforce the required steps

JDBC Receiver Adapter - SYNC Select step by step /people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

JDBC Stored Procedures /people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Regards,

Mike