HI All..
I am trying to execute a FCC to JDBC scenario. Where i am trying to execute stored procedure.
This is my paylaod for inbound message
<?xml version="1.0" encoding="utf-8" ?>
- <ns:STP_Test_Input_DT xmlns:ns="http://MCDBtest">
- <Record>
- <Root>
<Data1>007</Data1>
<Data2>PALMONE</Data2>
</Root>
- <Root>
<Data1>001</Data1>
<Data2>GAURAV</Data2>
</Root>
</Record>
</ns:STP_Test_Input_DT>
I am not able to map it to the output structure.
it is showing only this..
<?xml version="1.0" encoding="UTF-8"?>
<ns0:STP_Test_Output_MT xmlns:ns0="http://MCDBtest"><Statement><stored_Proc_Name action="EXECUTE"></stored_Proc_Name></Statement></ns0:STP_Test_Output_MT>
can you help me with the kind of output structure i require to map it correctly
i have created input and output as follows
record
root
data1
data2
for FCC and
statement
action
data1
isInput
type
data2
isInput
type
for JDBC stored procedure execution
i have tried with
statement
action
record
root
data1
isInput
type
data2
isInput
type
but still not able to map the payload correctly.