Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can Stored Procedure communicate w/ Windows COM object?
Hi Tim.
In 8.1.6 you could use the COM Automation Feature (refer to technet.oracle.com docs for 8.1.6 for more info).
In short, you can drive any COM object from within PL/SQL. I've tried a couple of MickeyMouse examples (driving Excel) and it seems to be OK but for production work i'd be pretty wary. COM is pretty unstable.
HTH, Dave
"Tim Bramlet" <tbramlet_at_fairway.com> wrote in message
news:oLG46.500$xZ3.114686_at_news.uswest.net...
> 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 Wed Jan 03 2001 - 18:18:38 CST