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