Re: Same Procedure runs and fails intermittently

From: D Rolfe <dwrolfeFRUITBAT_at_orindasoft.com>
Date: Wed, 26 May 2004 20:40:07 +0100
Message-ID: <po6tc.597$Z14.545@news.indigo.ie>

Tyler,
> In response to D Rolfe ------
> I am not sure if data should be at a transient stage at anytime.
> When you examine the ACID properties of an RDBMS
> Under consistency there should be no time when
> data is under an interim/transient stage.Data
> will be seen as under the initial or final stage.
>

Never mind what the theory says. Find out what actually is happening.

to_date works on nulls and properly formatted dates. Your to_date must be getting something else.

Since you are working with a varchar2(20) field instead of a date field you have to accept the practical possability of data which does not format as a date properly.

David Rolfe
Orinda Software
Dublin Ireland Received on Wed May 26 2004 - 14:40:07 CDT