Re: a question for stored procedure

In article <4gg7bt$hbq_at_gatekeeper.tasb.org>,

   xia__chr_at_tasb.org (Chris Xia) wrote:
>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

the DBA_OBJECTS synonym doesn't exist unless you run catdbsyn.sql to create it. once it exists, you can select from it in pl/sql.

--
Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.