Just put the select before the activation of each procedure in your program and after the last one: BEGIN SELECT TO_CHAR(sysdate,'MM/DD/YYYY HH:MI:SS') FROM dual; p1; SELECT TO_CHAR(sysdate,'MM/DD/YYYY HH:MI:SS') FROM dual; p2; SELECT TO_CHAR(sysdate,'MM/DD/YYYY HH:MI:SS') FROM dual; p3; SELECT TO_CHAR(sysdate,'MM/DD/YYYY HH:MI:SS') FROM dual; p4; SELECT TO_CHAR(sysdate,'MM/DD/YYYY HH:MI:SS') FROM dual; COMMIT; EXCEPTION WHEN OTHERS THEN ROLLBACK; END;
Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -----Original Message----- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Thu, January 24, 2002 3:00 PM > To: Multiple recipients of list ORACLE-L > Subject: Ang: Re: Ang: Re: PL/SQL procedure - error > > > But which query asks for the start date of the procedure an dwhich > selectstatement is to display th etime when th eprocedure starts. > > Roland > > > > > > [EMAIL PROTECTED]@fatcity.com den 2002-01-22 08:25 PST > > Sänd svar till [EMAIL PROTECTED] > > Sänt av: [EMAIL PROTECTED] > > > Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Kopia: > > > Use SELECT TO_CHAR(sysdate,'MM/DD/YYYY HH:MI:SS FROM dual; > > Rick > > > > Roland.Skoldb > [EMAIL PROTECTED] To: Multiple recipients of > list ORACLE-L <[EMAIL PROTECTED]> > Sent by: cc: > root@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" <[EMAIL PROTECTED]>@fatcity.com den 2002-01-22 > 04:40 PST > > Sänd svar till [EMAIL PROTECTED] > > Sänt av: [EMAIL PROTECTED] > > > Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > 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: [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). > > > > > > > > > > -- > 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). > > > > > -- > 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). > > > > > > > > > > -- > 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). > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > This e-mail was scanned by the eSafe Mail Gateway > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?àãø_éçéàì? 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).