Re: No rollback

astalavista wrote:
> Hi,
>
> I did for loop to insert a lot of rows (PL/SQL)
> I killed the session
> I surprised not to see any rollback occured...
>
> What I missed ?
>
> Thanks in advance
>
> 9.2.0.6 on windows 2000

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.

-- 
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