cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic select from Oracle database

Former Member
0 Kudos

Hello,

I have scenario from oracle to file.

In JDBC sender adapter I have this statement:

SELECT * FROM OPEN_FRIDAYS_VW WHERE ID =197

I'm looking for the way to insert dynamic ID (instead off the number 197) via web page to communication channel.

Elad

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Elad,

Unfortunately sender JDBC channel can not take dynamic values. But you can redesign your interface to achieve your requirement.

Web Appln (HTTP post) -> XI <->JDBC(rcr)->XI->Final target

Remember JDBC receiver channel works in Synch mode.

You need to implement a BPM for this.

Regards,

Jaishnkar

Former Member
0 Kudos

Hi Elad,

for this, you have to map the select statement into a dedicated Message-Typ:

http://help.sap.com/saphelp_erp2005vp/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Sample:

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:MT_Insert xmlns:ns0="http://xxxxxxxxx">

- <FreeNameForMessageType>

- <dbTableName action="select">

<table>YourTable</table>

- <access>

<ID>MappedValue</ID>

</access>

</dbTableName>

</FreeNameForMessageType>

Regards Mario