We use a similiar method which involves inserting periodic rows into a log table, which is dumped to a file at end-of-job.
Scott Shafer San Antonio, TX 210.581.6217 > -----Original Message----- > From: Kirtikumar Deshpande [SMTP:[EMAIL PROTECTED] > Sent: Tuesday, June 24, 2003 2:05 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: log for transaction > > Oracle does not have any ready-made logging process to assist you. > Some of our developers have utilized 'utl_file' to track the progress of > their long running jobs. > Entries are made to the job log file at proper intervals to tell them what > happened in case the > job aborted. > > - Kirti > > --- [EMAIL PROTECTED] wrote: > > Hi there, > > > > I got a question on log. If my program crashes, can I check some log to > see what > > recent transaction is? It will give me a big help on trouble shooting. > > > > Thanks, > > Jin > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).