Oracle Database Discussions

I am unable to insert into a VIEW which uses a UNION ALL query. At least I'm sort of unable to. If I use a direct sql stmt against the VIEW it works. If I try to insert via TOAD or Oracle Forms, I get stopped.

When I remove the UNION ALL and the query below, leaving the same INSTEAD OF TRIGGER in place, there's no problem.

What could be causing this dichotomy between these environments? (Also, the ALL_UPDATABLE_COLUMNS says the view is not insertable, even though the direct SQL stmt still works).

Thanks,
Chuck