Re: Trigger insert on parent table question

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Fri, 04 Feb 2005 11:30:21 -0800
Message-ID: <1107545257.408822_at_yasure>


Sean wrote:

> Hey all, I'm new to triggers and I don't know if what I want is
> possible.
>
>
> I have a parent table, dbobjects say. And I have a persons table.
>
> bdobjects.id is a primary key
> persons.id is a primary key and references dbobjecs.id.
>
> Descriptively what I want is:
>
> Before insert on persons
> Insert a row in the dbobjects table *sys_guid() is default for this
> column*
> Iake the value of the new dbojects.id field and assign it to the
> persons.id field of the row about to be inserted
> Continue with persons insert
>
> Can this be done? Oracle 10g BTW.
>
> Thanks so much

Anything can be done. But two questions: 1. Why are you deciding how you want to do something rather than

    stating a business case?

2. Why didn't you just try it?

Personally I think you are creating great complexity where simplicity would suffice.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Fri Feb 04 2005 - 20:30:21 CET

Original text of this message