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

    how do you run two SQL statements in one Page Process

    Metabaron

      Hi,

       

      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.