Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Stored Procedure: Transfering data from one table to another from one db to another

Stored Procedure: Transfering data from one table to another from one db to another

From: RKNR3755 <rknr3755_at_yahoo.com>
Date: 2 Feb 2003 08:10:50 -0800
Message-ID: <9cfa4c94.0302020810.75ca6255@posting.google.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
Received on Sun Feb 02 2003 - 10:10:50 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US