JDBC Receiver<Table Name TAG> dynamically by Stored Proc name.

[Former Member]

We have a scenario of where we update 30 Variant tables and the corresponding tables in Oracle are updated by respective Stored Proc.

Idea is to have a interface which support updating all the tables.

The issue is, in a JDBC Receiver adapter the name of the tag in the data type has to be the name of the Stored Proc to be executed, but we have 30 different Stored Procs.

Eg.

<DT_Table Name>

<Statement Name>

<b> <Store Proc Name> I Want this dynamically</b>

Action

Table (Store proc name- I currently get this dynamically, but I also want the above tag name dynamic with.)

< Access>

Field1…….

FieldN.

I want <Store Proc Name> tag name dynamically but it is predefined in data type with a specific value( Genrally with store proc or table names). If this is not possible, do I have to create 30 different data types?, or is there any other alternative to handle the scenario.

Message was edited by:

Suresh Deshpande

[henrique_pinto]

Try to create a .xsd file with 30 different optional <Store Proc Name> fields.

Then, in your mapping, create only 1 of the 30 fields, based on the content of your input message.

Regards,

Henrique.