Dumb question - was: Why does my relationship conflict with my trigger?

My appologies for asking, but why do you use fully qualified table names? (ie the TSS. portion in your example) None of the systems I've worked on have used this. DBAs usually insist on removing this as it presents a major headache at times. Is there a new convention that makes this preferrable? (I'm not being snarky as there may well be, but I'm just not up with the times...;-) I ask because there was a poor soul asking about multiple instances a few weeks ago because some purchased package had this construction & presented some mjor headaches for him.

Where's this come from & why? Aren't synonyms and database links preferable? Any pointers are appreciated.

Thanks.

EM

>
> > > > Trigger
> > > > ---------------------------------------------------------
> > > > CREATE OR REPLACE TRIGGER "TSS".UT_PERSONNEL
> > > > BEFORE UPDATE ON "TSS"."STI_PERSONNEL"
> > > > REFERENCING OLD AS OLD NEW AS NEW
> > > > FOR EACH ROW
> > > > BEGIN
> > > >
> > > > /* Handle the first name change. */
> > > > IF :NEW.FNAME != :OLD.FNAME THEN
> > > > INSERT INTO TSS.STI_PERSONNEL_HISTORY
> > > > (ID,PERSONNEL_ID,CHANGE_DATE,OLD_VALUE,NEW_VALUE,DESCRIPTION)
> > > > VALUES
Received on Mon Jan 29 2001 - 18:06:23 CST