4 Replies Latest reply: Dec 13, 2013 10:16 AM by jwellsnh RSS

    how do you run two SQL statements in one Page Process




      i have a page process that runs two SQL statements.


      The first statement is running.


      the 2nd is not.


      the SQL is:


      delete from com_mailshots ms
      where ms.mailshot_id = :P12_MAILSHOT_ID;

      delete from com_log logg
      where logg.mailshot_id = :P12_MAILSHOT_ID;


      as i siad the first statement works and the 2nd does not. this works when i run it threw SQL developer, so there' s nothing wrong with the statement.