Oracle запрашивает несколько операторов удаления из.NET

Question

У меня проблема с выполнением простого запроса в Oracle из.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);

Я использую Dapper в качестве легкого ORM там. Наверное, даже не зная Даппера, все ясно.

Вот исключение:

ORA-00933: SQL command not properly ended

Answer 1

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);