Skip to Content
0
Former Member
Feb 22, 2011 at 10:21 AM

Creating DataType for JDBC Receiver to Execute Stored Procedure

102 Views

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