xml message as a Procedure Parameter
Hi colleagues, perhaps you already have solved it because it seems to be a simple requirement, at least in its definition.
Here is the scenario: xml->(1)XI(2)->Oracle where (1) is a simple File adapter and (2) is a jdbc adapter.
The definition is as follows:
XI has to execute an Oracle Stored Procedure passing only one IN parameter: "the XI xml message itself", and suppose that the possible xmls are not to big, so, we don't have to deal with the complexity of Oracle CLOBs parameter type, using a simple Varchar2 IN parameter is enough. I'm not worry about the procedure but HOW to pass the entire original xml message.
Many thanks in advance, Esteban.
PD: When I refer to the XI message itself, I mean the original xml, without all the internal XI soap envelope info, etc; just the original xml.