Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle8 - mqseries

Re: oracle8 - mqseries

From: prunoki <hegyvari_at_ardents.hu>
Date: 5 May 2006 14:01:27 -0700
Message-ID: <1146862887.826139.214700@u72g2000cwu.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US