Re: Stored procedure access remote database

From: sv <vsachinmca_at_gmail.com>
Date: 12 Apr 2007 22:50:16 -0700
Message-ID: <1176443416.577073.189070@n59g2000hsh.googlegroups.com>

On Mar 26, 7: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

Try this one

Begin

   Insert into a(column_name)                /* Local Table */

   select (column_name) from b_at_remote_databse ; /* Remote Table */    commit; /* Transaction commis at Local Database */ End; Received on Fri Apr 13 2007 - 00:50:16 CDT