Need some pl/sql help

From: <Roland.Skoldblom_at_ica.se>
Date: Sat, 26 Jan 2002 21:18:05 -0800
Message-ID: <F001.003FC3D0.20020126210517@fatcity.com>

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 do this, please.

Thanks in advance

Roland

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Roland.Skoldblom_at_ica.se

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 Sat Jan 26 2002 - 23:18:05 CST