Schema References in PLSQL

In SQL one can refer to tables in other schemas using the . notation; e.g.

           SELECT * FROM systext.txsqe_name;

where txsqe_name is a table in the systext schema.

The same statement in PLSQL yields a "must be declared" error..

Going by way of a remote database link is one way to work around this shortcoming but I wonder if there isn't a direct way to refer to tables in other schemas in the same database instance from PLSQL code.

Comments? Advice?

Thanks, Scott
guthery_at_slb.com Received on Fri Jul 14 1995 - 00:00:00 CEST