Re: App Design: Logging to CLOB field

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sun, 09 Sep 2007 12:05:36 +0200
Message-ID: <fc0ghb$1n4$2@news2.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

DA Morgan wrote:
> Craig wrote:

>> "DA Morgan"
>>> And the point of using autonomous transactions is?
>>
>>
>> Always COMMIT the write to log..
>> but maybe not to the app process.
>>
>> Are you implying there is something wrong using AT in general or using
>> AT in this way ?
>>
>> thanks 

>
> No. Just trying to determine if it is hiding some unstated requirement.
> You do understand, using an autonomous transaction, that if the original
> statement rolls back the autonomous statement will still commit.
And, to complete the picture, committing the AT does not prevent you from rolling back the transaction?

• -- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFG48VwLw8L4IAs830RAs/uAJ0evGCmkQ/WzThNpzGCal41kiF1pgCfQSje vNC12/RzB8voEBQO5ta0o+c=
=gQ4m
-----END PGP SIGNATURE----- Received on Sun Sep 09 2007 - 05:05:36 CDT