1 Reply Latest reply: Mar 15, 2013 3:49 AM by 997106 RSS

    Distributed transactions

    464267
      Is there any possibility to continue fetching of cursor data after switching of global transactions?
      I start a global transaction using OCITransStart function, open cursor and fetch first block of data, then detach this transaction using OCITransDetach and start another global transaction, then detach the second one and resume the first transaction. After all these actions I try to fetch next block of data from the opened cursor but get the following error: ORA-01002: fetch out of sequence.