Fast bulk inserts from SAP PI to Oracle database

[Former Member]

Dear all,

I found the blog which related to bulk insert from SAP PI to Oracledatabase.

http://scn.sap.com/people/varun.mukund/blog/2010/03/25/fast-bulk-database-inserts-from-sap-pi

But I didn't clear how PI send the select query with in   this Insert query. How structure should be?  Could you please clear me about this if you understands?

Thank you.
Sateesh

[Former Member]

Hi Sateesh

I am also not able to understand how to insert select query in INSERT. But you can try to do the same using the below structure where you can write your complete query as string

<StatementName6>

<anyName action=” SQL_QUERY” | “SQL_DML”>

<access>SQL-String with optional placeholder(s)</access>

<key>

  <placeholder1>value1</placeholder1>

  <placeholder2>value2<placeholder2> 

</key>

</anyName > 

  </StatementName6>

Thanks,

Indrajit

[iaki_vila]

Hi Sateesh,

To achieve an INSERT with a SELECT clause the only way that i can imagine is using the SQL_DML format. Check this link Defining an SQL_QUERY Statement - Advanced Adapter Engine - SAP Library

I edit my post, check Badari Garre answer in that blog, he develops a XSLT with SQL_DML.

Regards.

Message was edited by: Iñaki Vila