Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL-How to access another database instance?
PL/SQL-How to access another database instance? [message #35834] Wed, 17 October 2001 21:43 Go to next message
David Jeyathilak
Messages: 9
Registered: October 2001
Junior Member
How
to access another database instance on the same server using PL/SQL?

----------------------------------------------------------------------
Re: PL/SQL-How to access another database instance? [message #35837 is a reply to message #35834] Thu, 18 October 2001 04:10 Go to previous message
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



----------------------------------------------------------------------
Previous Topic: Can a trigger do a commit?
Next Topic: How to (auto-)recompile dependencies?
Goto Forum:
  


Current Time: Thu Mar 28 03:06:19 CDT 2024