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

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^)

>
> 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.
>
> 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 Received on Thu Jun 03 2004 - 20:31:38 CEST