PLS-00302

From: Björn-Åke Segrell <pinne_at_pegit.se>
Date: Thu, 09 Dec 1999 23:29:26 +0000
Message-ID: <38503B55.C9069C72@pegit.se>

Hi,
Ora 8.0.5 on Solaris 2.6/RH Linux 5.2

When i create a package in one schema referencing a %ROWTYPE from a table in another
i get PLS-00302:"Component must be defined" I have granted SELECT (which i thought was enough) + a damn lot of other permission which
i know shouldn't be neccessary

XSAMPLE->
CREATE PACKAGE locpkg AS
locsettings Settings%ROWTYPE;
globsettings glob.Settings%ROWTYPE; -- THIS is where i get PLS-00302
.
.
.
.

END;
<- XSAMPLE

Anyone any ideas ?

/CHEERS Received on Thu Dec 09 1999 - 17:29:26 CST