Re: PLS-00201: identifier SYS.DBA_DATA_FILES must be declared

You don't have select privleges for that table. Try logging on as the DBA or have the DBA give you select privleges.

Ken

Ferran Foz wrote:

> I'm running on a very strange problem.
> I'm logging in to Oracle 7 with a username that has roles
> RESOURCE, CONNECT, DBA.
> I can do a "desc dba_data_files" but the following procedure does
> not compile...
> But the following procedure:
> procedure uuu is
> kk varchar2(1);
> begin
> select '1' into kk
> from dba_data_files
> where rownum=1;
> end;
> Errors for PROCEDURE UUU:
> LINE/COL ERROR
> ------------------------------------------------------------
> 4/1 PL/SQL: SQL Statement ignored
> 5/6 PLS-00201: identifier 'SYS.DBA_DATA_FILES' must be declared
>
Received on Fri Jul 09 1999 - 07:08:00 CDT