RE: Oracle 12 <-> DB2

Golden Gate just moves data. It doesn’t run any code.

Liz

Elizabeth Reen
CPB Database Group Manager
718.248.9930 (Office)
Service Now Group: CPB-ORACLE-DB-SUPPORT

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rob Lockard Sent: Thursday, June 08, 2017 5:15 PM
To: oracle-l_at_freelists.org
Subject: Re: Oracle 12 <-> DB2

Will Golden Gate call stored procedures on DB2? We have a lot of PL/SQL packages in Oracle that are calling stored procedures on DB2.

On 6/8/2017 5:08 PM, Andrew Kerber wrote: Golden Gate will work with DB2

Sent from my iPhone

On Jun 8, 2017, at 12:37 PM, Stefan Knecht <knecht.stefan_at_gmail.com<mailto:knecht.stefan_at_gmail.com>> wrote: Oracle Gateway can connect to DB2:

http://www.oracle.com/technetwork/database/gateways/index.html<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.oracle.com_technetwork_database_gateways_index.html&d=DwMCaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=agzoAVEgvCtD6mNtxJsEUeTMnu0qFop7XwgEvsEw7m0&s=ApfmAYG36JWAlYtFdxAzAmPE8vi_wwS1dvjlGNg1-Yw&e=>

On Fri, Jun 9, 2017 at 12:30 AM, rob oraclewizard.com<https://urldefense.proofpoint.com/v2/url?u=http-3A__oraclewizard.com&d=DwMCaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=agzoAVEgvCtD6mNtxJsEUeTMnu0qFop7XwgEvsEw7m0&s=6-KsFlDrmfNjJ-qKtPAmCyoZJve_xgDZ3dvPAyoBNP0&e=> <rob_at_oraclewizard.com<mailto:rob_at_oraclewizard.com>> wrote:

Does anyone know of a product that will give bi-directional communications from Oracle 12.2 to DB2 on System-Z. Oracle is calling a DB2 stored procedure that returns results. Right now we are using Start Quest to do this, The shop is upgrading from Oracle 10g -> 12.2, and can not get the Star Quest product to work. Thanks -Rob

--

"The question isn't who is going to let me; it's who is going to stop me."

Ayn Rand

Robert P. Lockard

www.oraclewizard.com<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.oraclewizard.com&d=DwMCaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=agzoAVEgvCtD6mNtxJsEUeTMnu0qFop7XwgEvsEw7m0&s=7_PS27XbhdcbTkPmMkdZxC-AvaXsdFLE-PxbIDSUcwA&e=>

(c) 571.276.4790

Twitter: _at_YourNavionPilot
--

http://www.freelists.org/webpage/oracle-l Received on Fri Jun 09 2017 - 15:29:22 CEST