Re: Trigger insert on parent table question

On 4 Feb 2005 07:44:23 -0800, SeanMartinFarrell_at_gmail.com (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.

Do I understand this correctly? You have a table whose PRIMARY key references another table's PRIMARY key? If I have that correct, you need to go back and review the rules of normalization, then re-work your design. As it stands now, 'objects' is no more the parent of 'persons' than 'persons' is of 'objects'.

>
>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

Thanks.

• Ed Stevens

Cohn's Law: The more time you spend in reporting on what you are doing, the less time you have to do anything. Stability is achieved when you spend all your time doing nothing but reporting on the nothing you are doing. Received on Fri Feb 04 2005 - 13:00:06 CST