query in trigger to another schema
From: News via skynet <x>
Date: Tue, 19 Mar 2002 15:36:48 +0100
Message-ID: <3c974d4a$0$263$ba620e4c_at_news.skynet.be>
Hi,
Date: Tue, 19 Mar 2002 15:36:48 +0100
Message-ID: <3c974d4a$0$263$ba620e4c_at_news.skynet.be>
Hi,
[Quoted] In a trigger in a particular schema I want to retrieve data from another schema AUTH. While doing this the compiler gives PLS-00201. I have to declare the identifier somehow. Any clues?
my query in the trigger:
BEGIN
SELECT USER.NAME FROM AUTH.USER
WHERE USER.NAME = :new.USER;
....
END; Received on Tue Mar 19 2002 - 15:36:48 CET