Re: a question for stored procedure

Chris Xia wrote:
>
> Hi, there:
>
> I have a simple question about stored procedure:
>
> Can I access tables that are not inside my schema when I create a stored procedure?
>
> According to the syntax of pl/sql , seems I should be able to do that , but I always
>
> got the error:
>
> 4/1 PL/SQL: SQL Statement ignored
> 4/33 PLS-00201: identifier 'DBA_OBJECTS' must be declared
>
> Any help would be appreciated!
>
>
>
>

Hi Chris,
perhaps you need a GRANT SELECT ON SYS.DBA_OBJECTS TO USER ???.

Hope it helps

Juergen.

-- 
************************************************
Juergen Pelz                mailto:pelz_at_zdf.de
ZDF                         http://www.zdf.de
Abt. PFS                    
55100 Mainz                 Tel: 06131-70 3608
************************************************

This is my private opinion !!!