On 9 May 2012, at 10:33am, ext-esko.huja...@elektrobit.com wrote:
1: SAVEPOINT 1
2: insert A
3: RELEASE SAVEPOINT 1
4: SAVEPOINT 2
5: insert B
6: ROLLBACK TO SAVEPOINT 2
ROLLBACK in line 6 cancels also line 2 in addition to line 5.
I want to cancel just line 5.
What it does
Hi All,
1: SAVEPOINT 1
2: insert A
3: RELEASE SAVEPOINT 1
4: SAVEPOINT 2
5: insert B
6: ROLLBACK TO SAVEPOINT 2
ROLLBACK in line 6 cancels also line 2 in addition to line 5.
I want to cancel just line 5.
What am I doing wrong ?
br,
Esko
On 9 May 2012 10:33, ext-esko.huja...@elektrobit.com wrote:
Hi All,
1: SAVEPOINT 1
2: insert A
3: RELEASE SAVEPOINT 1
4: SAVEPOINT 2
5: insert B
6: ROLLBACK TO SAVEPOINT 2
ROLLBACK in line 6 cancels also line 2 in addition to line 5.
I want to cancel just line 5.
What am I doing
On Wed, May 9, 2012 at 5:33 AM, ext-esko.huja...@elektrobit.com wrote:
Hi All,
1: SAVEPOINT 1
2: insert A
3: RELEASE SAVEPOINT 1
4: SAVEPOINT 2
5: insert B
6: ROLLBACK TO SAVEPOINT 2
ROLLBACK in line 6 cancels also line 2 in addition to line 5.
I want to cancel just line 5.
On 9 May 2012, at 10:33am, ext-esko.huja...@elektrobit.com wrote:
1: SAVEPOINT 1
2: insert A
3: RELEASE SAVEPOINT 1
4: SAVEPOINT 2
5: insert B
6: ROLLBACK TO SAVEPOINT 2
ROLLBACK in line 6 cancels also line 2 in addition to line 5.
I want to cancel just line 5.
What it does