Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to delete data before insert in oracle database

Hi friends,

I have one scenario.I want to send data from sap to Oracle database.Befor i am inserting data in database table,i want to clean/delete all the records in the table .This interface will run twice in a day.Can any body help me.

SAP-PI-JDBC

Thanks

Ravi

Former Member
Former Member replied

Check your DATA TYPE attributes with the attributes of the column names in the Database table. There is a mismatch between the DT and Table in the database.

also, check the following:

Stored Procedure in SQL Server 2005

/people/praveen.gujjeti/blog/2009/01/29/best-practices-with-receiver-jdbc-adapter-document-formats

Edited by: Puneet Singhal on Mar 21, 2011 7:06 PM

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question