JDBC Receiver ( how to execute a SP from PI in some cases)

[erodmor]

Hi

i need to execute a SP on some cases after i do the insert on the SQL database,

(I now about the solution to insert using the SP and there validate when i need to execute the SP, but in this case they cannot make the SP the DB team)

i need to execute this SP when my message has a value of message sent (heres my graphics mapping im using), it works, but on the result

<?xml version="1.0" encoding="UTF-8"?><__EmptyDoc></__EmptyDoc>

my idea is to execute the 2 message mapping that has the Store Procedure execution, am i going the wrong way?

is theres a better way using a UDF?

[iaki_vila]

Hi Erick,

I think you will have you Insert action in your receiver adapter, then where do you go to call the SP?, are you going to use any lookup in the response time?, another  options are to use a ASYNC/SYNC bridge or BPM.

Finally, It is better to use standard functions than UDFs.

Regards.