Re: Oracle 8.0.4 and date corruption

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 23 Jan 1999 17:31:01 -0000
Message-ID: <917112671.8336.0.nnrp-06.9e984b29@news.demon.co.uk>

It has been possible with earlier versions of Oracle to push illegal values into date columns using Pro*C/OCI.

The problem was usually a program setting a bind variable type to an internal date type (12 I think) which bypassed the normal validation.

Perhaps this has happened in your case.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Paulo Pinheiro wrote in message <78cjla$40f$1_at_duke.telepac.pt>...
>I have an oracle 8.0.4 database and i found some records
>of type DATE which have worng information like
>'6824-85-71'
>
>
>Any ideas?
>
>Thank you
>
>
>
Received on Sat Jan 23 1999 - 11:31:01 CST