Re: PLS-00302

A copy of this was sent to Björn-Åke Segrell <pinne_at_pegit.se> (if that email address didn't require changing) On Thu, 09 Dec 1999 23:29:26 +0000, you wrote:

>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
>

did you grant via a role?

see http://osi.oracle.com/~tkyte/Misc/RolesAndProcedures.html
>
>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
--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Dec 10 1999 - 15:48:54 CST