Re: ora-01847 when updating a record...please help

From: Simon <smuckers70_at_hotmail.com>
Date: 4 Jun 2004 00:33:08 -0700
Message-ID: <c0475b73.0406032333.5dd4c3c9_at_posting.google.com>


ed.prochak_at_magicinterface.com (Ed prochak) wrote in message news:<4b5394b2.0406031031.771d9265_at_posting.google.com>...
> smuckers70_at_hotmail.com (Simon) wrote in message news:<c0475b73.0406030222.655092cd_at_posting.google.com>...
> []
> >
> >
> >
> > Ed,
> >
> > Thanks for that ..if only I could change the model!!..i am working
> > with a package solution. The table is designed to hold loads of
> > different types of code, so it had to be defined as varchar. The
> > subsection of data I was trying to update had no invalid data
> > formats...but other values in the same column did, my update statement
> > must have been wrong because it was these values that were causing the
> > problem.
>
> Not necessarily the update portion, but the WHERE clause. But does
> that mean I won the bet? Too bad I didn't put money on it. 8^)

  Always the way isn't it! I would have one thousands on if only bets!

>
> >
> > I have taken a lazy way out though...i created a table by selecting
> > the values and updated the new table. I then deleted the old subset of
> > data and reinserted the values from my new table. It worked and was
> > only a one-off so I am fairly happy.
>
> So is anyone going to go back and fix the bad dates so this doesn't
> happen next time? If you have to stay with VARCHAR at least try to
> clean it up.

  I didn't really answer you properly here, the data causing a problem was not 'date' data, but character based....my where clause just did not seperate out the correct records...why it didn't is another story, one that I don't really know!! If you saw some of the data models I had to work with, you would feel very sorry for me!!!

> >
> > Thanks for your help.....
>
> You are welcome. It is nice to get feedback on whether proposed
> solutions really work, so thanks to you too.
>
> Ed

 cheers...... Received on Fri Jun 04 2004 - 09:33:08 CEST

Original text of this message