Dear Roland,
        first try to use your brain than ask in this group.
Yesterday I've posted email about Exceptions in Oracle (to catch an error)
and the tip - don't use datatype DATE to store start/end time.
OK, the second tip:
PROCEDURE my_procedure ( ....
....
....
COMMIT;
RETURN;
EXCEPTION
WHEN OTHERS THEN
        ROLLBACK;
        INSERT INTO status_table VALUES( strt_dt, end_dt
,'my_procedure','OTHERS', err_mesage);
        COMMIT;
END;

JP

On Tue 26. March 2002 12:18, you wrote:
> Hallo,
>
> > Can anyone give me an example on a pl/sql code, which does the following:
> >
> > I have 4 procedures, and I want the following to be logged in a status
> > table.
> >
> > Procedure names
> > Start_time of procedure
> > End_time_of procedure
> > Error_code(if anything goes wrong)
> > Error_message
> >
> > Please give me example onhow to write the code and also tell me how to
> > pick out the procedure_name, start_time of_procedure, end_time_ptocedure,
> > error_code, error_message.
> >
> > Thanks in advance.And just dontgive me a link, i wantthis real example
> > too.
> >
> > Roland S
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).

Reply via email to