TRIGGERS referencing <different user> table

From: Radek Hulan <ivan2000_at_technologist.com>
Date: 1997/06/06
Message-ID: <3397C74E.FA18FE17@technologist.com>#1/1

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_at_technologist.com
Konojedska 33, Prague, Czech Republic Received on Fri Jun 06 1997 - 00:00:00 CDT