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

Home -> Community -> Usenet -> c.d.o.server -> dbms_hs_passthrough

dbms_hs_passthrough

From: rjgst3 <rjgst3_at_rmu.edu>
Date: 14 Mar 2007 19:07:16 -0700
Message-ID: <1173924436.121013.216430@d57g2000hsg.googlegroups.com>


I attempting to move data from Oracle 10g to Teradata database using dbms_hs_passthrough and running into some issues. Of course moving data over a dblink sucks, but I have some limitation. Regardless, here it is....

  1. Is there a way using hs_passthrough to call a 'Recordset' and loop thru the recordset to insert into a remote database?

I suppose this is a start...

Any help will work. Received on Wed Mar 14 2007 - 21:07:16 CDT

Original text of this message

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