Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Limit UPDATE statements to affect only one row

Re: Limit UPDATE statements to affect only one row

From: bernard (bernard_at_bosvark.com) <bernard_at_bosvark.com>
Date: 11 Aug 2006 05:40:42 -0700
Message-ID: <1155300042.855087.102750@m79g2000cwm.googlegroups.com>


Can not misuse instead of trigger on table ORA:25002: cannot create INSTEAD OF triggers on tables Version:10.2.0.1

So a view it will be (nope is can't be used I'm told) since it breaks Hibernate (aaaaargh!!!!!!) which discovers the data relationships through foreign keys on tables to effectively generate the code (ouch!).

Any more ideas are welcome.

Regards
Bernard

P.S. Fight the use Hibernate in all circumstances unless you want to limit the functionality of Oracle by 80% since Hibernate attempts to create database independence (yea right). Received on Fri Aug 11 2006 - 07:40:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US