Re: oracle8 - mqseries

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 5 May 2006 12:02:16 -0700
Message-ID: <1146855736.151830.113800@g10g2000cwb.googlegroups.com>

prunoki wrote:
> Hi,
>
> We need to send and receive XML files to/from another application via
> MQSeries and we would like to do it using PL/SQL on the server. Our
> current approach is to load the necessary classes into the Oracle JVM,
> write some Java code using the MQSeries API and use wrappers to call
> them from PLSQL.
>
> I am curious if any of you tried this before and I am also interested
> in alternative approaches. We are currently working on the concepts
> document. Currently we have to stick to Oracle 8.1.7.
>
> Regards,
>
> Hegyvari Krisztian

Of course the standard disclaimer is how old 8.1.7.

Oracle has offered good integration with MQSeries for a long time.

What you have noted sounds doable.

You might want to stash the files you receive into a blob first ( keep them safely received ) and process them separately. Or perhaps not. Received on Fri May 05 2006 - 14:02:16 CDT