Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Ang: Re: Ang: Re: PL/SQL procedure - error

Ang: Re: Ang: Re: PL/SQL procedure - error

From: <Roland.Skoldblom_at_ica.se>
Date: Thu, 24 Jan 2002 05:20:50 -0800
Message-ID: <F001.003F9A73.20020124050026@fatcity.com>

But which query asks for the start date of the procedure an dwhich selectstatement is to display th etime when th eprocedure starts.

Roland

Rick_Cale_at_teamhealth.com_at_fatcity.com den 2002-01-22 08:25 PST

Sänd svar till ORACLE-L_at_fatcity.com

Sänt av: root_at_fatcity.com

Till: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Kopia:

Use SELECT TO_CHAR(sysdate,'MM/DD/YYYY HH:MI:SS FROM dual;

Rick

                    Roland.Skoldb
                    lom_at_ica.se           To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>
                    Sent by:             cc:
                    root_at_fatcity.        Subject:     Ang: Re: PL/SQL procedure - error
                    com


                    01/22/2002
                    09:15 AM
                    Please
                    respond to
                    ORACLE-L







Thanks,

and can you please tell me how to get hold of the time when the procedures starts and finishes.?

Thanks in advance.

Roland

"Pullikol Kumar" <pullikol.kumar_at_mannai.com.qa>@fatcity.com den 2002-01-22 04:40 PST Sänd svar till ORACLE-L_at_fatcity.com

Sänt av: root_at_fatcity.com

Till: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Kopia:

 hi Roland

  Hope below code will help u,

BEGIN

    p1;
    p2;
    p3;
    p4;

  COMMIT;
 EXCEPTION
 WHEN OTHERS THEN
  ROLLBACK;
END; procedure p1
is
BEGIN
 insert into aa values (1,'1');
END;
procedure p2
is
BEGIN
 insert into aa values (2,'2');
END;
procedure p3
is
BEGIN
 insert into aa values (3,'3');
END; procedure p4
is
BEGIN
 insert into aa values (4,'4');
END; 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).

--

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:
  INET: Rick_Cale_at_teamhealth.com

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:
  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 Thu Jan 24 2002 - 07:20:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US