RE: Pl/SQL help - please help me

From: Kimberly Smith <ksmith2_at_myfirstlink.net>
Date: Mon, 28 Jan 2002 07:25:20 -0800
Message-ID: <F001.003FD24C.20020128071032@fatcity.com>

I suggest you go buy yourself a good PL/SQL manual. Nothing that you are asking for here is all that complicated. I recommend the O'Reilly book "The Oracle PL/SQL CD Bookshelf".

-----Original Message-----

Roland.Skoldblom_at_ica.se
Sent: Sunday, January 27, 2002 9:15 PM
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: 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).

--

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

Author: Kimberly Smith
INET: ksmith2_at_myfirstlink.net

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