DELETE sql statement for on-prem database — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DELETE sql statement for on-prem database

in EPM Platform and Freeform 3 comments

Summary:

Has anybody found a way to run a DELETE sql statement before exporting data to an on-prem database using Data Integration? In Applications, there is field that takes the query name. So I setup a Query (DELETE_TABLE) which has the DELETE statement preceding the INSERT statement

The error I am getting is ORA-00933: SQL command not properly ended

If I remove the DELETE statement, my INSERT works correctly. I maybe trying to game the query which is meant for INSERT only, but has anybody found a way for us from EPM end to clear the data in the target Oracle sql table before populating the table with our exported data.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!