ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » General Discussion » help on MQSeries - Oracle PL/SQL Langauge support

Post new topic  Reply to topic
 help on MQSeries - Oracle PL/SQL Langauge support « View previous topic :: View next topic » 
Author Message
Vishy
PostPosted: Mon Aug 04, 2003 6:51 am    Post subject: help on MQSeries - Oracle PL/SQL Langauge support Reply with quote

Novice

Joined: 30 Jul 2003
Posts: 21
Hi.
I am new to MQ Series technology and in the process of learning.
My work requires extracting records from Oracle 8i table, put that into a message in a Q and send to PeopleSoft. The team is primarily composed
of Oracle developers and want to make less use of Java code.

I am thinking of two approaches

1) Java Stored Procedures approach
Write a Java class with methods to initialize the connection, put the message on Q and send the message.
2) Then call those methods from Oracle PL/SQL code

IS THAT POSSIBLE?

2) MQSeries - Oracle PL/SQL Langauge support Support PAC
I found a link on IBM MQ website for direct MQSeries - Oracle PL/SQL support at the following link. Has anyone used this approach.http://www- 3.ibm.com/software/integration/support/supportpacs/individual/ma0i.html

Has anyone used either of these approaches, if so please do let me now. Please do suggest if there is any other better approach. Thanks in afvance

Vishy
Back to top
View user's profile Send private message Yahoo Messenger
Michael Dag
PostPosted: Wed Aug 06, 2003 11:00 pm    Post subject: Reply with quote

Jedi Knight

Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
Vishy, the oracle PL/SQL package works in both server and client mode.
for simple MQ connectivity this is sufficient. There is a security exposure as it uses the Oracle External Procedure Listener, which can be connected to from outside your machine so you have to restrict access there otherwise someone else can pretend to be your app. Also from within the machine you have to grant rights to the MQ procs in Oracle, the Oracle listener is running on it's own userid and that userid needs to be assigned rights to the Queues.

So 2 Oracle apps on the same machine on the same listener can access the same queues on MQ and 'can' pretend to be the other app.
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Vishy
PostPosted: Mon Aug 11, 2003 5:48 am    Post subject: Thanks Reply with quote

Novice

Joined: 30 Jul 2003
Posts: 21
Thanks Dag for your input. Shall certainly take note of that point.

Thanks
Back to top
View user's profile Send private message Yahoo Messenger
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » General Discussion » help on MQSeries - Oracle PL/SQL Langauge support
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.