Re: insert / updating on mandatory 1:1 relationship

Bruce,

  You can use INSTEAD OF triggers to perform exactly what you are looking for. This option is available in Oracle 8 and higher.

HTH,
Brian

Bruce Van Horn wrote:
>
> If it were up to me, the table wouldn't contain such constraints but
> triggers instead that would be more flexible with what I want to
> accomplish.
>
> However, I didn't create the table, and I can't readily modify it
> since applications from other departments already run against it. The
> functionality used to access the database is compiled within a Java
> class so that's no help. I could decompile if I knew which one
> contained the functionality I need, but there are hundreds of classes
> within the jars that make up the apps.
>
> I am writing a different app that will access the tables. I was
> hoping for a peice of SQL I had not considered.
>
> On Sat, 16 Sep 2000 11:09:09 GMT, Chun-Yen <agichen_at_my-deja.com>
> wrote:
>
> >In article <39c30e40.262365008_at_news.supernews.com>,
> > bvh2_at_swbell.net (Bruce Van Horn) wrote:
> >> If two tables have a mandatory 1:1 relationship, is there any way to
> >> insert or update values in these tables without disable the constraint
> >> first? Will a trigger or stored proc do this?
> >>
> >
> >Why didn't you combine them ??
> >--
> >U can use set constraint deferrable.
> >
> >
> >
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================