From: Radek Hulan <ivan2000@technologist.com>
Subject: TRIGGERS referencing <different user> table
Date: 1997/06/06
Message-ID: <3397C74E.FA18FE17@technologist.com>#1/1
X-Priority: 3 (Normal)
Organization: TOTAL  SOLUTIONS, LTD
Newsgroups: comp.databases.oracle.server



Could anyone help me about HOW to reference a different user table
in BEFORE INSERT trigger? I want to fill in some :new fields which 
were created under USER_A with values from tables created under 
USER_B (by using simple select statement).

If I try something like SELECT xxx INTO :new.yyy FROM USER_B.TABLE
WHERE ... (on USER_A.this_trigger), it doesnt work. I tried also 
using synonyms, but with no luck.

Thanks in advance.

Radek Hulan
e-mail: ivan2000@technologist.com
Konojedska 33, Prague, Czech Republic