| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle and MQ
The VB
programs have data validation and standard error trapping for exceptions
returned by the MQ API calls. As for your question about
accessing external procs, MQ provides the API to make calls from C which
you can certainly use to code the external routines. Another possibility
is to use the MQ Java API to code Java stored procs. Then you won't have
to handle the listener issues related to external procs and other server
dependencies. That's what we would implement if the MQ management
responsibilities are ever transferred to us in the DBA
group.
<FONT face=Arial color=#0000ff
size=2>
Tony
Aponte
<FONT face=Arial color=#0000ff
size=2>
<FONT
size=2><FONT face=Arial
color=#0000ff>
<SPAN
class=529304217-21112001> -----Original Message-----From:
YTTRI Lisa [mailto:lisa.yttri_at_cnh.com]Sent: Wednesday, November 21,
2001 10:59 AMTo: Aponte, Tony;
'ORACLE-L_at_fatcity.com'Subject: RE: Oracle and
MQ
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 <FONT
size=2>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
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 - 14:30:25 CST
 |
 |