Skip to Content
Former Member
Jan 16, 2009 at 01:05 PM

Dynamic Table insertion using JDBC



I am using SAP XI to insert data from SAP database To oracle database.

I have to insert data into 40 different tables.

Is there any possible way through which I can insert data to these 40 different tables using same scenario.

Since we can define TABLE NAME as a variable.. is it possible to define fields as variable?

I have successfully configured a scenario using the following blog:


but the problem is we have to give table field names as constants... Is it possible to declared it dynamically.

Thanks in advance