Re: connect to a remote Oracle db using PLSQL procedure

claudiagambetta_at_tiscali.it (Claudia Gambetta) writes:

> I need to connect to a remote Oracle db using PLSQL procedure.
> I don't know if it's possible and what is the right way to solve
> this problem.
> I tried to use "connect username/password_at_service_name" like SQLPlus
> but this command is not on hand in PLSQL.
>
> Help me, Please.
> Claudia (Italy, Rome)

What about just defining a database link? e.g. CREATE DATABASE LINK otherdb CONNECT TO scott IDENTIFIED BY tiger USING 'DBNAME.world';

Then you can just access remote objects by qualifying them with the @link_name e.g.

SELECT sysdate FROM dual_at_otherdb;

Tim

--