Receiver JDBC Scenario with DELETE query and WHERE clause

[former_member185881]

Hello All

In my Interface receiver side is JDBC.

My Receiver Structure is as below:

I wanted to DELETE particular rows from Oracle database first and then INSERT some rows.

In Statement1 --> row --> action : I have written query DELETE FROM ABC WHERE NAME <> 'XYZ'

In Statement2 --> row --> action : I have written INSERT

Kindly help me if DELETE  query can be written with where clause in message mapping.

I am getting error "Unsupported action attribute value 'DELETE FROM ABC  WHERE NAME <> 'XYZ' found in XML document"

Kindly help

Regards

Dheeraj Kumar

[former_member185881 · Accepted solution]

Hello All

To solve above problem refer below blog

Regards

Dheeraj Kumar

[former_member184720]

Refer to statement 3 structure to define where clause for DELETE transactions

http://help.sap.com/saphelp_srm40/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.html

  <StatementName3>

<dbTableName action=”DELETE”>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

  </StatementName3>