JDBC Receiver ( how to execute a SP from PI in some cases)
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?