Re: Error creating package

On Thu, 14 Feb 2002 19:59:05 +0100, Lothar Armbruester <lothar.armbruester_at_t-online.de> wrote:

>Andy Rigby wrote:
>>
>> SQL> create or replace package body adoDemo
>> 2 as
>> 3 procedure getEmployees(p_cursor out rc_emp) is
>> 4 begin
>> 5 open p_cursor for select ename from MYSCHEMA.TBL19;
>> 6 end getEmployees;
>> 7 end adoDemo;
>> 8 /
>>
>> There are 2 errors which appear:
>>
>> 5/25 PL/SQL Statement ignored
>> 5/43 PLS-00201: identifier 'MYSCHEMA.TBL19' must be declared
>>
>> But MYSCHEMA.TBL19 exists and I can select from it (select * from
>> MYSCHEMA.TBL19) so I cannot see where the problem lies.
>>
>Hello Andy,
>this sounds to me like a FMF (frequently made fault :-).
>In PL/SQL roles do not work so you have to grant the select privilege
>directly to the user creating the package.
>
>Hope that helps,
>Lothar

Where the FMF is not RTM and not searching for a FAQ in the numerous resources floating around the Internet explaining this feature.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Feb 14 2002 - 13:57:22 CST