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

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Thu, 04 Jan 2001 00:14:52 +0000
Message-ID: <3A53C07C.2B477199_at_rdbms.freeserve.co.uk>


Tim,

Sounds like a job for external procedures (EXTPROC), map the dll, get the callbacks right, and it's functions into a library and away you go.

Chris

Tim Bramlet 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
Received on Thu Jan 04 2001 - 01:14:52 CET

Original text of this message