>I have hardly used savepoints in any application, but if I understand >it correctly, isn't it something which is typically used >in a persistent connection. I wonder how it is applicable in a web >based stateless application like Amazon.com, unless >even web based application have database level state. Doesn't need to be a long running connection, you can trap exceptions, roll back, and do something else all in the SQL code or a function from a single call. -- Sent from my Android device with K-9 Mail. Please excuse my brevity.