You'd *think* that, wouldn't you? My problem is the OCI bug which allows this: Typ=12 Len=7: 100,100,0,0,1,1,1 Perhaps we can make some workarounds... <sigh> Thanks Daniel and Igor! Rich Rich Jesse System/Database Administrator rich.jesse@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA > -----Original Message----- > From: Daniel Fink [mailto:Daniel.Fink@xxxxxxx] > Sent: Wednesday, February 25, 2004 3:32 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: Re: Reading DUMP of DATE field > [snip] > The reason for the excess is that the value cannot be stored > as a 0, even > though 0 is allowable in some fields. Obviously we don't have > a month 0 nor day > 0. > > Daniel ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------