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

Home -> Community -> Usenet -> c.d.o.server -> Re: App Design: Logging to CLOB field

Re: App Design: Logging to CLOB field

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 08 Sep 2007 10:07:56 -0700
Message-ID: <1189271268.601813@bubbleator.drizzle.com>


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.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Sep 08 2007 - 12:07:56 CDT

Original text of this message

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