Re: Newbie: Select in PL/SQL

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