Hi Roland,
Best way to do this is just set some variables at the start of your code:
l_proc_start := sysdate;
l_proc_name := 'proc_name';
begin
...commands...
exception
when <exception> then
l_proc_end := sysdate;
SELECT count(*)
INTO l_ins_count
FROM <table being inserted to>;
INSERT INTO error_table
( proc_name
,proc_start
,proc_end
,proc_count
,proc_err
,proc_err_msg
)
VALUES
( l_proc_name
,l_proc_start
,l_proc_end
,l_ins_count
,sqlcode
,sqlerrm
);
COMMIT;
END;
-----Original Message-----
Sent: 28 January 2002 08:40
To: Multiple recipients of list ORACLE-L
Hallo,
anyone who canhelp me with this?
I have PL/sql procedure and if something goes wrong I would like the
following things to occur. Please help me with them
If some errors occur I want this to happen.
- pick out the name of the procedure thatis currently running,
-pick out the start_time of the procedure
- pick outthe end_time of the procedure when it fails
- pick out the number of rows that were inserted inthe insertstatement inthe
procedure.
- The error code
_Th errormessage
All these things I want to be inserted in a table. Give me a good example on
how to write the code, please.
Thanks in advance
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thomas, Kevin
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).
