Referencing Package from another schema

From: <martin.dsouza_at_gmail.com>
Date: 28 Dec 2004 07:40:56 -0800
Message-ID: <1104248456.830589.267110@z14g2000cwz.googlegroups.com>

Hi,

I'm trying to reference a package from another schema in a trigger...

The trigger code is:

BEGIN
SELECT <seq_name>.nextval
INTO other_schema.global_package.identity -- Where identity is a global variable
FROM dual;
:new.TEXTID:=other_schema.global_package.identity; END; I get the following error message:

Error Text = PLS-00201: identifier 'other_schema.global_package' must be declared.

The package that I created works fine. Any ideas? thanks Received on Tue Dec 28 2004 - 09:40:56 CST