Re: Pl/sql question

>- pick out the name of the procedure thatis currently running,
check http://osi.oracle.com/~tkyte/who_called_me/index.html, dbms_utility.get_call_stack, dbms_utility.get_error_stack
>-pick out the start_time of the procedure
discussed some days ago
>- pick outthe end_time of the procedure when it fails
just sysdate
>- pick out the number of rows that were inserted inthe insertstatement
inthe procedure.
already discuseed
>- The error code

sqlcode,
dbms_utility.get_error_stack
>_Th errormessage

sqlerrm
dbms_utility.get_error_stack

>All these things I want to be inserted in a table. Give me a good example
on how to write the code, please.
You may use simple procedure that picks some arguments like start_time, end_time, proc_name, inserted/not inserted rows, error info and inserts it in a table
Just use autonomous transactions. More - read docs, it is well documented in Oracle guides.
Starting points - technet.oracle.com, docs.oracle.com, metalink.oracle.com (only to members :((( )

Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: G.Plivna_at_itsystems.lv

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).