Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Incredible ! Oracle HELP PLEASE !

Re: Incredible ! Oracle HELP PLEASE !

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 28 Jun 2002 11:42:53 +0100
Message-ID: <3d1c3dad$0$8506$ed9e5944@reading.news.pipex.net>


Christian wrote
> Ooopss...
> I didn't understand you wanted to rollback your transactions...
> I don't see anything else than code around your problem :
> The transaction should only be made when you are sure that it must be
commited.
> For example, your application should only perform an insert/commit when
your end user
> clics commit. If he clics rollback, nothing should be sent to the
database.

I'm not entirely sure how you would achieve this but anyway what do you do about rollbacks caused for reasons other than and end user choosing not to save their work. eg tablespace full - unable to extend temp segment by x etc.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
Received on Fri Jun 28 2002 - 05:42:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US