Re: Can you prevent commits from a client application?

From: gazzag <>
Date: Wed, 9 Jul 2008 02:50:57 -0700 (PDT)
Message-ID: <>

On 8 Jul, 18:55, dean <> wrote:
> 10g. Is there any way to alter a session and prevent ANY commits (at
> least until a subsequent call to remove the alteration)? I'm using the
> following statement to prevent commits in any procedures (ALTER
> SESSION DISABLE COMMIT IN PROCEDURE), but I need a way to prevent
> accidental commits from within a client application.
> The reason I would like this is to allow testers to be able to
> navigate around an application after a databridge has been run, and
> poke around here and there in various datagrids, without risk of them
> accidentally calling a function that has a commit in it.
> Any thoughts appreciated.

Flashback database any use?

HTH -g Received on Wed Jul 09 2008 - 04:50:57 CDT

Original text of this message