RE: Oracle and MQ

[YTTRI Lisa]

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:[EMAIL PROTECTED]]
Sent: Tuesday, November 20, 2001 4:02 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: 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:[EMAIL PROTECTED]]
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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).