Re: a question for stored procedure

In article <4gg7bt$hbq_at_gatekeeper.tasb.org>, xia__chr_at_tasb.org (Chris Xia) writes:
|> From: xia__chr_at_tasb.org (Chris Xia)
|> Newsgroups: comp.databases.oracle
|> Subject: a question for stored procedure
|> Date: 21 Feb 1996 22:46:21 GMT
|> Organization: Texas Association of School Boards, Inc.
|> Lines: 22
|> Message-ID: <4gg7bt$hbq_at_gatekeeper.tasb.org>
|> Reply-To: xia__chr_at_tasb.org
|> NNTP-Posting-Host: baghdad.tasb.org
|>
|> 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!
|>
You have been granted SELECT on DBA_OBJECTS via a role (the DBA role, no doubt). All roles are disabled in stored procedures. You need to connect as SYS, and GRANT SELECT ON dba_objects directly to yourself.   

|>
|>
|>
|>
|>
Received on Thu Feb 22 1996 - 00:00:00 CET