Date: Fri, 4 Aug 2000 16:35:48 GMT
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Organization: Deja.com - Before you buy.
Subject: Re: bad data in Oracle killing query
SAS crashes out of the query...I was able to pull the information by
using SPSS however that is not a great solution.
In article <email@example.com>,
"Jon" <firstname.lastname@example.org> wrote:
> I have also run into a similar problem. In Oracle the field had a
> value, but SAS read it (admittedly it did complain), but reported the
> as 17nov1858. Since the database only started recording data in cc
> was an easy task to weed this one out.
> Unfortunately I do not know a work around. In your case, does SAS
> out, or continue to read data past this point?
> <email@example.com> wrote in message
> > I'm trying to pull some data from an Oracle table and running into
> > trouble. I have a date field in a table that seems to have bad
> > it giving me the error message...
> > "CLI cursor fetch error: [Oracle][ODBC Oracle Driver]Invalid date,
> > or timestamp value."
> > Is there any way around this?
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Sent via Deja.com http://www.deja.com/
Before you buy.