CODEWITHSUNDEEP
c#sqloracle-databaseodp.netodac
Andrei
Andrei

Reputation: 44640

Oracle query multiple delete statements from .NET

I've got issue with executing simple query in Oracle from .NET (ODP):

        const string sql = @"
            delete from CLIENTS where CAMPAIGN_ID = :campaignId
            delete from OPERATORS where CAMPAIGN_ID = :campaignId
            delete from CAMPAIGNS_EXCLUDE_DAYS where CAMPAIGN_ID = :campaignId
            delete from CAMPAIGNS where ID = :campaignId";

        var p = new DynamicParameters();
        p.Add("campaignId", campaignId);

        Connection.Execute(sql, p);

I am using Dapper as light weight ORM there. Probably even without knowing Dapper it's all clear.

Here is an exception:

ORA-00933: SQL command not properly ended

Upvotes: 1

Views: 1253

Answers (1)

Filipe Silva
Filipe Silva

Reputation: 21657

const string sql = @"
     delete from CLIENTS where CAMPAIGN_ID = @campaignId
     delete from OPERATORS where CAMPAIGN_ID = @campaignId
     delete from CAMPAIGNS_EXCLUDE_DAYS where CAMPAIGN_ID = @campaignId
     delete from CAMPAIGNS where ID = @campaignId";

var p = new { campaignId=campaignId };
Connection.Execute(sql, p);

Upvotes: 1

Related Questions