Listers:
You have 2 DBs, "L" local, "R" remote. From within a PL/SQL package or procedure on the *local* DB, is it legal to:
declare a local variable using a *remote* type:
MyVar_L userR.pkgR.typeR@dblinkR;
or call a *remote* procedure:
userR.procR(...)@dblinkR;
If it is legal to reference remote pkg/procs, is my syntax correct?
If it is not, how do I accomplish this without having someone login to the remote DB?
Thanx,
Alan Martin
Principal Consultant
Defense Logistics Information Service
Battle Creek, MI
