Re: No rollback

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 21 Jul 2007 10:08:15 -0700
Message-ID: <1185037694.436326@bubbleator.drizzle.com>

astalavista wrote:

>> Not able to look over your shoulder and read your code I haven't the
>> slightest idea in the world. Perhaps your code contains the keyword
>> COMMIT. Or perhaps you didn't kill the session, but rather killed the
>> client and the procedure completed. Who can say?
>>
>> Next post include enough information that someone can help you.

>
> Thanks, th code was
> 1 begin
> 2 for i in 1..10000000
> 3 loop
> 4 insert into big values (i, 'titi');
> 5 end loop;
> 6* end;
> SQL> /
>
> no commit at all
> the session was killed

What was the client software? Does it or its driver autocommit?

How do you know the session was killed?
  ... how was it killed? Give us the exact syntax.   ... Did you look in gv$session and verify it?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sat Jul 21 2007 - 12:08:15 CDT