Thanks Frank. But the table that I am inserting from has a CLOB
column. And this insert does not work because of this. Do you know
how I can solve this?
"Frank" <F.Preikschat_at_gmx.de> wrote in message news:<b1jma2$9ar$1_at_news1.ewetel.de>...
> if you have installed "distributed option" you can create a database-link
> an use this link.
>
> create public database link db_link
> connect to scott identified by tiger
> using 'TNSNAMES-ENTRY';
>
> insert into table_at_db_link
> as select * from table;
>
> Frank (Germany)
>
> RKNR3755 <rknr3755_at_yahoo.com> schrieb in im Newsbeitrag:
> 9cfa4c94.0302020810.75ca6255_at_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 Mon Feb 03 2003 - 10:57:24 CST
