RE: Oracle and MQ

From: YTTRI Lisa <lisa.yttri_at_cnh.com>
Date: Wed, 21 Nov 2001 08:34:40 -0800
Message-ID: <F001.003CAC6A.20011121080335@fatcity.com>

Tony -

<FONT face=Arial color=#0000ff

size=2> 
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?
<FONT face=Arial color=#0000ff

size=2> 
Do you
think it would also be possible to access MQ via external stored procedures?

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Aponte, Tony   [mailto:AponteT_at_hsn.net]Sent: Tuesday, November 20, 2001 4:02   PMTo: ORACLE-L_at_fatcity.comCc:
  lisa.yttri_at_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 [<A
  href="mailto:lisa.yttri_at_cnh.com">mailto:lisa.yttri_at_cnh.com]   Sent: Tuesday, November 20, 2001 11:50 AM <FONT   size=2>To: Multiple recipients of list ORACLE-L <FONT   size=2>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 <FONT

  size=2>-- Please see the official ORACLE-L FAQ: <A 
  href="http://www.orafaq.com">http://www.orafaq.com <FONT 
  size=2>-- Author: YTTRI  Lisa <FONT 
  size=2>  INET: lisa.yttri_at_cnh.com 

  Fat City Network Services    -- (858)   538-5051  FAX: (858) 538-5051 San Diego,   California        -- Public Internet access   / Mailing Lists <FONT

  size=2>-------------------------------------------------------------------- 

  To REMOVE yourself from this mailing list, send an E-Mail   message to: ListGuru_at_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). Received on Wed Nov 21 2001 - 10:34:40 CST