Hello all,
I have the following scenario:
an external program is calling my XI system which has a webservice enabled as a SOAP sender communication channel.
now, i need to pass the input over to a remote system with PCK installed on it which needs to execute a stored procedure on an oracle database via the jdbc adapter.
The jdbc adapter is deployed and working well on the PCK engine.
When I pass an xml message over to the Webservice, its also OK (in the adapter monitoring).
my question is - how can i pass the input parameters from the WS over to the PCK and then over to the JDBC adapter to execute the Stored procedure (which only writes the data).
I saw that the data type and message types of the message going to the JDBC need to be in special format including the name of the SP, action=execute and all the parameters with attribute type=datatype.
all of that is done already.
However, i still do not understand where/how does the PCK get the message and invokes the JDBC adapter for processing.
Many thanks for you help!!!