Re: Trigger insert on parent table question

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)