Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Newbie: Select in PL/SQL
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