0 Replies Latest reply: Sep 16, 2013 11:50 AM by 980427 RSS

    What defines a Transaction in an ODI Procedure?

    980427

      There are multiple Transactions (Autocommit and Transaction 0 through Transaction 9) that can be chosen and different commit options that can be set for each Transaction. Is a a Transaction defined by a semi-colon?

       

      Is it the case where an actual procedure (DECLARE, BEGIN, END) is counted as Transaction 0 and if individual sql statements (DML or DDL) are used with the odi procedure command, then each sql statement that is ended by a semi-colon (oracle) is treated as a different Transaction?

       

      I just don't see how the actual Transaction drop down list relates to the Command. I mean isn't there only 1 Transaction per Command and that's why we can have multiple Commands in a procedure?