Re: Can Stored Procedure communicate w/ Windows COM object?

In 8i, a s.p. may be written in either Java or PL/SQL.

In Java, it is easy to call a COM object.

In PL/SQL, you should theoretically be able to spawn a call to it. I have used this technique on Unix machines to call external programs (e.g., to call an MQ daemon to pass off a message), but I have never tried this in the Micro$oft world.

hth -

In article <MLG46.503$xZ3.115021_at_news.uswest.net>,   "Tim Bramlet" <tbramlet_at_fairway.com> wrote:
> Using Oracle 8.1.6 on Win NT.
>
> We are evaluating alternatives for communicating with a 3rd party
> application via their COM object and are looking at pros and cons...
>
> One alternative is writing an external program that communicates
 directly
> with the 3rd party app via the COM object and with the database via
 pipes or
> queuing...
>
> A preferred alternative for portability would be communicating
 directly with
> the COM object from the database. Is it possible, reliable and does
 anyone
> have any experience sending and recieving messages directly between a
 stored
> procedure and a COM object?
>
> Thanks,
> Tim
>
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 03 2001 - 16:46:15 CET