Re: Pl/SQL help - please help me

From: Pullikol Kumar <pullikol.kumar_at_mannai.com.qa>
Date: Mon, 28 Jan 2002 02:16:37 -0800
Message-ID: <F001.003FCB4F.20020128010654@fatcity.com>

PROCEDURE A as
 stack_info VARCHAR2(4096);
 BEGIN
  lv_time:=lv_time:= to_char(sysdate,'DD/MON/YYYY HH:MI:SS AM');   dbms_output.put_line('Start-B -'||lv_time);     B;
  lv_time:=lv_time:= to_char(sysdate,'DD/MON/YYYY HH:MI:SS AM');   dbms_output.put_line('End-B -'||lv_time);     EXCEPTION
  WHEN OTHERS THEN
    stack_info:=DBMS_UTILITY.FORMAT_CALL_STACK;     dbms_output.put_line(stack_info);
 END;

---

 PROCEDURE B as
  stack_info VARCHAR2(4096);
  BEGIN
    lv_time:=lv_time:= to_char(sysdate,'DD/MON/YYYY HH:MI:SS AM');     dbms_output.put_line('Start-C -'||lv_time);     C;
    lv_time:=lv_time:= to_char(sysdate,'DD/MON/YYYY HH:MI:SS AM');     dbms_output.put_line('End-C -'||lv_time);  EXCEPTION
 WHEN OTHERS THEN
    stack_info:=DBMS_UTILITY.FORMAT_CALL_STACK;     dbms_output.put_line(stack_info);
 END;

---

 PROCEDURE C as
  stack_info VARCHAR2(4096);
   i NUMBER :=0;
 BEGIN

• Division By Zero will Rise INSERT INTO ttt VALUES(7/0);

 EXCEPTION WHEN OTHERS THEN
    stack_info:=DBMS_UTILITY.FORMAT_CALL_STACK;     dbms_output.put_line(stack_info);

• The error code _The errormessage dbms_output.put_line(TO_CHAR(SQLCODE)||'-'||SQLERRM); END;

  ---

  • pick out the name of the procedure that is currently running,
  • pick out the start_time of the procedure
  • pick out the end_time of the procedure

This eg. will do Above Question.

set serveroutput on
BEGIN
   lv_time varchar2(60);
 DECLARE
 BEGIN

• Procedure A Start Time lv_time:=lv_time:= to_char(sysdate,'DD/MON/YYYY HH:MI:SS AM'); dbms_output.put_line('Start- A -'||lv_time); A lv_time:=lv_time:= to_char(sysdate,'DD/MON/YYYY HH:MI:SS AM'); dbms_output.put_line('End- A -'||lv_time);
• Procedure A Start Time END; END;

  ---

CREATE TABLE ttt
 (

   f1                         NUMBER

 )

Nitheesh

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Pullikol Kumar
  INET: pullikol.kumar_at_mannai.com.qa

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 Mon Jan 28 2002 - 04:16:37 CST