Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Newbie: Select in PL/SQL

Newbie: Select in PL/SQL

From: GREGORY KNESER <gregoryk_at_futures.wharton.upenn.edu>
Date: 28 Oct 2001 06:45:04 GMT
Message-ID: <9rg9hg$7pl$2@netnews.upenn.edu> 





Hello,



We're having problems with selects in our pl/sql statements.  We can do 
selects just fine except for the situations where the table we want to 
select from is outside of the schema that the stored procecdure is 
located in.  What can we do to give the stored procedures the ability to 
see tables outside of their own schema?  All users have been granted the 
DBA role.



Thanks,


Greg
Received on Sun Oct 28 2001 - 01:45:04 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US