Re: *****pl/sql**********
Date: 2000/04/20
Message-ID: <8dmcku$1uma$1_at_buty.wanadoo.nl>#1/1
Maybe use the Oracle Open Client Adapter (so ODBC).
I have a FORMS application reading data in Foxpro table and inserting into
Oracle. It works very well.
The question is now: is it possible to use it in a storage procedure or
within SQLPLUS?
dhruba a écrit dans le message <8dlh3u$psj$1_at_nnrp1.deja.com>...
>Hi
>
>I have oracle 8.1.5 in NT4 server,
>from sqlplus on this box I can connect to oracle and to another
>db2 database(remote) which is on 0s/390,
>I have 2 common table both on oracle and db2 database.
>
>I need to write a pl/sql which will select data from db2 table and
>insert into oracle table.
>
>I am confused as when I am selecting data from db2 that is actually
>not in this box but in a terminal like,
>
>How can I capture that db2(remote) data and put into oracle(local)table.
>
>please give some advice
>
>rcy
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu Apr 20 2000 - 00:00:00 CEST