Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can't select from ALL_TABLES in a stored procedure
> Roles are not enabled in a procedure.
> Execute "set role none" and then your statements in SQL*Plus and I bet
you'll get only 64 records.
>
> Hope this helps
> Michel Cadot
>
>
Thanks, this helps me produce the undesired behaviour ;-)
But what should I do? Will it work if DBA grants me select on all_tables?
Received on Sat Oct 25 2003 - 16:33:34 CDT