RE: pL/SQL PROCEDUR

2002-03-27 Thread Paul Vincent
: [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR om 03/26/2002 12:23 AM Please respond to ORACLE-L Hallo, Can anyone give me an example on a pl/sql code, which does

Re: pL/SQL PROCEDUR

2002-03-26 Thread DBarbour
: [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR om

RE: pL/SQL PROCEDUR

2002-03-26 Thread Mark Leith
ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR om 03/26/2002 12:23 AM Please respond to ORACLE-L

RE: pL/SQL PROCEDUR

2002-03-26 Thread Grabowy, Chris
]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR om 03/26/2002 12:23 AM Please

Re: pL/SQL PROCEDUR

2002-03-26 Thread Jan Pruner
: pL/SQL PROCEDUR om 03/26/2002 12:23 AM Please respond to ORACLE-L Hallo, Can anyone give me an example on a pl/sql code, which does the following: I have 4 procedures, and I want

RE: pL/SQL PROCEDUR

2002-03-26 Thread Mercadante, Thomas F
PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR om 03/26/2002 12:23 AM

RE: pL/SQL PROCEDUR

2002-03-26 Thread Grabowy, Chris
] Sent by: cc: [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR om 03/26/2002 12:23 AM Please respond to ORACLE-L Hallo, Can anyone give

RE: pL/SQL PROCEDUR

2002-03-26 Thread Mercadante, Thomas F
DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR

Re: pL/SQL PROCEDUR

2002-03-26 Thread bill thater
[EMAIL PROTECTED] wrote: you forgot DNA sample. Rachel's good, but come-on! not THAT good. wanna bet?;-) PS for those of you who remember and were following my job saga, we were sold yesterday. well, partly sold anyway. the closing is 4/10 and we're still not sure if there will be any

PL/SQL - procedur

2002-03-25 Thread Roland . Skoldblom
Hallo, Can anyone give me an example on a pl/sql code, which does the following: I have 4 procedures, and I want the following to be logged in a status table. Procedure names Start_time of procedure End_time_of procedure Error_code(if anything goes wrong) Error_message Please give me example

Re: PL/SQL - procedur

2002-03-25 Thread Jan Pruner
Look at Exception in PL/SQL and how to use it. http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a77069/11_elems.htm#8355 And don't use 'date' type of variable to store start time and end time of your procedures. JP On Mon 25. March 2002 12:23, you wrote: Hallo,

RE: PL/SQL - procedur

2002-03-25 Thread Jesse, Rich
Jan, Could you explain why you say not to use the DATE datatype? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, March 25, 2002 6:33 AM To: Multiple recipients of

RE: RE: PL/SQL - procedur

2002-03-25 Thread Stephane Faroult
Could you explain why you say not to use the DATE datatype? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA Because of the 1s precision limit. The obvious workaround is to have PL/SQL procedures which

Re: PL/SQL - procedur

2002-03-25 Thread Jan Pruner
Because it stores only seconds and if your procedure's runtime is short ( 1 sec) you will get the same numbers. Other problem is: if you call same procedure in LOOP, you will get 1 - 2 - 5 ... 15 ... 500 records with same value in start and end time column. And (I think so) there's no way

pL/SQL PROCEDUR

2002-03-25 Thread Roland . Skoldblom
Hallo, Can anyone give me an example on a pl/sql code, which does the following: I have 4 procedures, and I want the following to be logged in a status table. Procedure names Start_time of procedure End_time_of procedure Error_code(if anything goes wrong) Error_message Please give me