Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newshosting.com!news-xfer2.atl.newshosting.com!nntp-relay.ihug.net!ihug.co.nz!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: rknr3755@yahoo.com (RKNR3755)
Newsgroups: comp.databases.oracle.misc
Subject: Stored Procedure: Transfering data from one table to another from one db to another
Date: 2 Feb 2003 08:10:50 -0800
Organization: http://groups.google.com/
Lines: 14
Message-ID: <9cfa4c94.0302020810.75ca6255@posting.google.com>
NNTP-Posting-Host: 66.185.84.198
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1044202250 18418 127.0.0.1 (2 Feb 2003 16:10:50 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 2 Feb 2003 16:10:50 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.misc:92601
X-Received-Date: Sun, 02 Feb 2003 09:10:08 MST (news.easynews.com)

Hi experts,

I would like to write a stored procedure that would copy data in a
table from
one instance of db to another(both oracle).  

The problem I am trying to solve is:  I have data in one table in an
instance of database.  When the web user clicks on the submit button,
my java code should execute the stored procedure that would transfer
the data.

Can anyone help me how I should go about writing a stored procedure
and copying the data.
thanks in advance