Re: PL/SQL - procedure

From: Jan Pruner <jan_at_pruner.cz>
Date: Tue, 26 Mar 2002 04:28:21 -0800
Message-ID: <F001.00432ED2.20020326042821@fatcity.com>

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: jan_at_pruner.cz

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: ListGuru_at_fatcity.com (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).

Received on Tue Mar 26 2002 - 06:28:21 CST