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: Detecting Commits

Re: Detecting Commits

From: Matthew MacFarland <matthew_macfarland_at_dril-quip.com>
Date: Wed, 7 Oct 1998 16:18:30 -0500
Message-ID: <6vglq4$dqh$1@uuneo.neosoft.com>


Hello Steve,

I have since solved the problem by other means. I was trying to deterimine that time that rows got commited versus the time that the insert statement was processed.

Thanks,

Matthew
Steve Haynes wrote in message ...
>In article <6vdqm9$jn7$1_at_uuneo.neosoft.com>, Matthew MacFarland
><matthew_macfarland_at_dril-quip.com> writes
>>Does anybody know a way to detect when users transactions get commited? I
>>need to build an audit table with a USER and DATE record for each commit
>>that takes place in order to debug an application.
>>
>This is a very strange thing to want to do.
>I suspect you would have to write a commit_it() procedure
>and insert into my_audit_record(user,date) yourself.
>Obviously replacing existing commits with a call to your
>new commit_it() procedure.
>Strange, OK I give in, why do you want to do this?
>Steve
>--
>Please remove nospam from my address to Reply.
Received on Wed Oct 07 1998 - 16:18:30 CDT

Original text of this message

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