ODBC connections (views aren't updateable even with INSTEAD_OF triggers)

Hi all,

I have some users who have presented a good case for needing ODBC connectivity to the database so they can re-position locations via ARC-GIS or MapInfo.

However I've discovered that (at least it appears that), ODBC doesn't recognize that updateable views are updateable. It looks like it just sees a view and instantly responds as they aren't updateable.

All of my business logic is built around views and INSTEAD_OF triggers, so all of the codes are translated for the user etc. I also would rather not have the user directly access the underlying base tables if at all possible, since that bypasses all of the business rules, but I'm stumped as to how to approach this.

I can't seem to apply the same logic in triggers on the tables, as commits are involved updating the parent table when a child is updated.

Have others run this situation as well, and if so, how have you tackled the situation?

Thanks.

--

• Bill Ferguson

--
http://www.freelists.org/webpage/oracle-l