Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle8 - mqseries
hpuxrac wrote:
> 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.
I agree, too bad it is not up to us to decide.
Of course we intend to set up a queue for both outgoing and incoming xml-s and do the job in an asynchronous manner. Received on Fri May 05 2006 - 16:01:27 CDT