Hi,
I've created ESR objects for a scenario where i want to execute a stored procedure in a receiver JDBC channel.
I would like to have some feedback to see if i did it correctly, and if my mapping is correct.
(i cannot test it yet for lack of database and stored procedure)
My source will have two parameters
My target will take these parameters and execute stored procedure with it
In my target datatype i've created as follows
DT_Anything
Statement element 1:unbounded
get_Anything element 1
action attribute required
Parameter1 element 1
type attribute required
isInput attribute required
Parameter2 element 1
type attribute required
isInput attribute required
Then in my mapping i map constant "VARCHAR" --> @type
and constant "true" --> @isInput.
So when i test my mapping it comes out as
<?xml version="1.0" encoding="UTF-8"?>
<ns0:MT_Anything xmlns:ns0="urn:company:scenario">
<Statement>
<get_Anything action="EXECUTE">
<Parameter1 type="VARCHAR" isInput="true">111</Parameter1>
<Parameter2 type="VARCHAR" isInput="true">222</Parameter2>
</get_Anything>
</Statement>
</ns0:MT_Anything>
Did i do this correct?
Kr
Robert