|
Re: PL/SQL-How to access another database instance? [message #35837 is a reply to message #35834] |
Thu, 18 October 2001 04:10 |
Phenoracle
Messages: 35 Registered: March 2001
|
Member |
|
|
Hi,
I'm not sure what you mean, but you can
access objects in PL/SQL as you would in SQL
via a database link e.g.
DECLARE
CURSOR cEmp
IS
SELECT *
FROM emp@emptst;
BEGIN
FOR rEmp IN cEmp LOOP
.....
END LOOP;
END;
If you want I have a tip on PL/SQL and database links
on my site called Transparent Procedures.
http://www.phenoarcle.co.uk
Have Fun
Rae
----------------------------------------------------------------------
|
|
|