Referencing table in another schema from package definition

From: Björn-Åke Segrell <pinne_at_pegit.se>
Date: Fri, 10 Dec 1999 21:29:54 +0000
Message-ID: <385170D2.53B1DBDB@pegit.se>

Running Oracle 8.05 on RH Linux 5.2.
When I try to reference a table in another schema in a package definition i get a PLS-00302 error:
"Component must be defined".

In schema2 it goes like this:

CREATE OR REPLACE PACKAGE pkg2 AS

reftab schema1.Table1%ROWTYPE; -- The offending reference. END; Schema2 has been granted select on Table1 in schema1 and i can SELECT from and DESCRIBE
schema1.Table when logged in as schema2 from within Sqlplus.

If someone could give me some hints on this i'd be very grateful. It's driving me crazy.

/CHEERS Received on Fri Dec 10 1999 - 15:29:54 CST