Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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?

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question