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.




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


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

0 View this answer in context

Helpful Answer

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