Title: PL/SQL proc calls to a remote DB via DB link
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
Title: PL/SQL proc calls to a remote DB via DB link
Try
it, you might like it. You might also get your answer quicker than asking
the list.
I
can't find a place where I defined a variable using a remote package but I seem
to remember doing the same type of thing using remote tables