Re: How do I use views in a stored procedure?

> I want to create a procedure as system, with a select from dba_segments,
> which is a view. Whenever I try to compile this procedure, I get the
> following error: PLS-00201: identifier 'SYS.DBA_SEGMENTS' must be declared
> How do I get around this problem?

Have your DBA grant you SELECT ANY TABLE and give it to your user account, not to one of your roles.

Regards,

Daniel A. Morgan Received on Mon Aug 17 1998 - 02:09:32 CDT