Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: NEVER MIND, SOLVED
Björn-Åke Segrell wrote:
> 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
DOUBLE DOOH & slap on me forehead.
For some reason I (shoudln't tell you this) had a public synonym named
Table1.
--
Vänliga hälsningar
Björn-Åke Segrell / Pegit AB
Email:pinne_at_pegit.se
Url:http://www.pegit.se
Phone:+46-(0)8-56030220, Fax:+46-(0)8-56034353
Received on Fri Dec 10 1999 - 16:42:47 CST
![]() |
![]() |