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 -> Newbie: Select in PL/SQL

Newbie: Select in PL/SQL

From: GREGORY KNESER <gregoryk_at_futures.wharton.upenn.edu>
Date: 28 Oct 2001 06:49:14 GMT
Message-ID: <9rg9pa$7pl$3@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. Received on Sun Oct 28 2001 - 01:49:14 CDT

Original text of this message

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