Oracle Database Discussions

Hi,

Logged as a given user, I can query the table DBA_SEGMENTS, but I cannot query it through a cursor or select into in a PL/SQL package.

I get the following error message:

LINE/COL ERROR

-------- -----------------------------------------------------------------

28/4     PL/SQL: SQL Statement ignored

33/5     PL/SQL: ORA-00942: table or view does not exist

28                     select

29                             count(*)

30                     into

31                             n

32                     from

33                             dba_segments;

Can someone explain me what is the missing privilege that I need?

Thanks by advance.

Kind Regards.