Connect to another DB

[Julia Sats]

Hi,

I need at my PL/SQL procedure get data from another DB.
What steps I need to do for it.

Thanks

[Ana C. Dent]

Re: Connect to another DB

Julia Sats wrote:

Hi,
>
I need at my PL/SQL procedure get data from another DB.
What steps I need to do for it.
>
Thanks
>
>

1)CREATE DATABASE LINK

2)modify tnsnames.ora

[LKBrwn_DBA]

Re: Connect to another DB


Create a database link.

--
Posted via http://dbforums.com

[Alan Mills]

Re: Connect to another DB


"Julia Sats" <julia.sats@sym patico.cawrote in message
news:nmAXa.2901 $ef7.302992@new s20.bellglobal. com...

Hi,
>
I need at my PL/SQL procedure get data from another DB.
What steps I need to do for it.
>
Thanks
>

Set up a adatabase link.