:
[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
:
[EMAIL PROTECTED] Subject: pL/SQL PROCEDUR
om
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
]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
: 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
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
]
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
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
[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
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
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,
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
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
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
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
15 matches
Mail list logo