PLS-00201: identifier SYS.DBA_DATA_FILES must be declared

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

Any idea?

Thanks a lot
--

• Ferran Foz mailto:ferran.foz_at_technologist.com
• STE Consulting, SA http://www.ste.es

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 09 1999 - 06:26:55 CDT