Re: Checking for uncommited transactions

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 06 Mar 2003 19:49:54 +0100
Message-ID: <0t5f6vsi5pok5etpbo943qrusivjd6f9bj@4ax.com>

On Thu, 06 Mar 2003 17:36:22 GMT, "FC" <flavio_at_tin.it> wrote:

>What's wrong with this scenario?
>

Read up transactions in the Oracle Concepts manual, starting at the very first line.

If an user 'exits from the form' he/she either needs to COMMIT or to ROLLBACK, because he/she started a transaction. A transaction starts whenever the user changes ANYTHING.
Users also DON'T make LOCAL CHANGES in a form, they are ALWAYS changing the database DIRECTLY.

You aren't OCP, by any chance?

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Mar 06 2003 - 12:49:54 CST