You are trying to convert data from type foo to type bar and this conversion is not possible. In SQL queries Oracle (and PG) do implicit conversion so it may very well happen that one query runs fine for a long time and then stops working because you've added "erroneous" data.
What is in line 71? What is in your data? Do you apply some explicit or implicit conversion there?
