Re: Stored procedure access remote database

On Mar 26, 4:44 pm, "Cliff Martin" <cliff.mar..._at_gmail.com> wrote:
> Hi,
>
> I am trying to write a stored procedure that can access a table on a
> remote database to insert some data on the calling server.
>
> Stored procedure would reside on Server A, establish some sort of
> database link to Server B, query the remote table, switch context back
> to the local server and insert data into a local table.
>
> Is this possible? What should I be searching for to get more
> information on how to do this?
>
> Any help is appreciated.
>
> Cliff

Wouldn't you better just issue
insert into <local_table>
select *
from <table>@remote_db
directly?
What you describe is very inefficient.
Look into the Distributed database manuals for further info.

--
Sybrand Bakker
Senior Oracle DBA