>>>>>>>Did he try validing the database as the help to this error suggests?
>>>>>>
>>>>>>Yes, we tried that to no avail.
>>>>>
>>>>>How about deleting the trigger's code and packing the database?
>>>>
>>>>Sorry, what trigger are you talking about?
>>>
>>>For the tables used in the view. Also, is it a remote view or local view?
>>
>>It's a local view.
>
>I would take a look at the tables the local view is hitting and check for any triggers in those tables, and perhaps reindex-pack the underlying tables as well.
OK, I'll suggest that. Thanks.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)