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

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

Re: Newbie: Select in PL/SQL

From: Ban Spam <ban-spam_at_operamail.com>
Date: Sun, 28 Oct 2001 14:53:29 GMT
Message-ID: <Xns91484621193EBSunnySD@24.0.3.73>


gregoryk_at_futures.wharton.upenn.edu (GREGORY KNESER) wrote in news:9rg9pa$7pl$3_at_netnews.upenn.edu:

> Hello,
>
> I'm trying to do a select on tables outside of the schema where the
> pl/sql procs are stored. All users in my DB have DBA role. When I
> write my select col1, col2 from other_schema.table_name I get an error
> "other_schema.table_name must be declared" If I create that exact same
> table in the schema where the proc is located and change the proc to
> select from the local table, it works just fine.
>
> Thanks for any help,
> Greg
>
> PS Sorry if this is a second post, my newsreader isn't working so hot
> tonight.
>

When logged into Oracle as USER1 & you want to access object owned by another user, this can be done via a number of ways. 1) select count(*) from USER2.TABLE_A;
2) CREATE SYNONYM TABLEA FOR USER2.TABLEA; Received on Sun Oct 28 2001 - 08:53:29 CST

Original text of this message

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