From lisa.yttri@cnh.com Wed, 21 Nov 2001 08:34:40 -0800 From: YTTRI Lisa Date: Wed, 21 Nov 2001 08:34:40 -0800 Subject: RE: Oracle and MQ Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: Oracle and MQ Tony -   Do you have error handling built in to your VB program, or do you just load it into Oracle and then cleanse/validate the data there?   Do you think it would also be possible to access MQ via external stored procedures? -----Original Message-----From: Aponte, Tony [mailto:AponteT@hsn.net]Sent: Tuesday, November 20, 2001 4:02 PMTo: ORACLE-L@fatcity.comCc: lisa.yttri@cnh.comSubject: RE: Oracle and MQ I believe Oracle sells an MQ-to-AQ bridge that just moves messages between queuing systems.  We use VB to pull messages out of MQ and issue SQL to get it into the database. HTH Tony Aponte -----Original Message----- From: YTTRI Lisa [mailto:lisa.yttri@cnh.com] Sent: Tuesday, November 20, 2001 11:50 AM To: Multiple recipients of list ORACLE-L Subject: OT: Oracle and MQ Hi - Does anyone have experience with using MQ w/Oracle.  We have an application that is using MQ to get data from the mainframe into Oracle.  We are trying to determine what our options are for retrieving the data from the MQ queues. We know one option is to write a Pro*C program to handle this, but this means creating all our own error logic, etc.  Does AQ fit into this scenario at all, or is that primarily for non-middleware queues? Any information / insight would be greatly appreciated. Thanks - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI  Lisa   INET: lisa.yttri@cnh.com Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing).