Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: connect to a remote Oracle db using PLSQL procedure
If you want to access data from that remote database you create a database
link, then refer to the tables as tablename_at_dblink where dblink is your
database link (which can either be specified in full or be resolved by
TNSNAMES.ORA, oracle name server, etc.
"Claudia Gambetta" <claudiagambetta_at_tiscali.it> wrote in message
news:9814fb76.0205300711.4159f7a_at_posting.google.com...
> 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)
Received on Thu May 30 2002 - 11:09:19 CDT