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

2002-01-24 Thread אדר יחיאל
l; > > Rick > > > > Roland.Skoldb > [EMAIL PROTECTED] To: Multiple recipients of > list ORACLE-L <[EMAIL PROTECTED]> > Sent by: cc: > root@fatcity.

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

2002-01-24 Thread Joe Raube
To: Multiple > recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent by: cc: > root@fatcity.Subject: Ang: Re: > PL/SQL procedure - error > com > > > 01/22/

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

2002-01-24 Thread Roland . Skoldblom
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, a

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

2002-01-22 Thread Rick_Cale
ct: Ang: Re: PL/SQL procedure - error

Ang: Re: PL/SQL procedure - error

2002-01-22 Thread Roland . Skoldblom
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 r

Re: PL/SQL procedure - error

2002-01-22 Thread Pullikol Kumar
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 v

PL/SQL procedure - error

2002-01-22 Thread Roland . Skoldblom
Hallo, anyone who can help me with a pl/sql procedure that I have four procedures that will run one after one: in an error table logs the procedurename, the start time of the procedure and the end time of the procedure.the number of rows inserted(there are insertstatements in the procedures),