Reg : Stored Procedure to XI

[Former Member]

Hi,

I need to know whether below is feasible using PI

Stored procedure is executed in oracle Database by DB people and the response should come to PI.

Please let me know if this is posible, if yes let me know how we can achieve this

Thanks,

Dinesh

[rajasekhar_reddy14 · Accepted solution]

ask them to store Stored procedure response in one table, then use JDBC sender channel to read data from that table.

it is realaly easy process.

Regards,

Raj

[Former Member]

Hi,

The JDBC adapter in PI uses the pull protocol where PI has to go add poll the table for data. JDBC will not be able to push the data into PI itself.

Regards

[Former Member]

Thanks everone..

[Former Member]

Hi,

They need to send the request via Http call...this should be included in Stored procedure for sending the request to PI..

Ask them to check this option...if that is possible (i think they can do that) then all you need is to design the http sender scenario...

HTH

Rajesh