Re: Calling a DLL from an Oracle Stored Procedure

You will need to write a program that runs on the server that can access the DLL. You must use dbms_pipe to communicate with this program. This setup will allow you to send data to the processes (which can access the dll) and get a result set returned to you. This can be very slow.

There is also an extention for Oracle (I can not remember what it is called) that will allow you to call DLL's from PL/SQL on Oracle 7. It was created because of the speed problems with using database pipe to communicate with a deamon process (described above). It is still slow and requires that the DLL be compiled through one of Oracle's precompilers.

As far as I know, these are the only two options that you have on Oracle 7.

Guy Rouillier wrote:
>
> I have Oracle 7.3.2.2. What is the indirect way? <gr> Seriously, I
> do need to know if I can do this. Thanks.
>
> marktoml_at_gdi.net (mark tomlinson) wrote:
>
> >On 6 Feb 1998 08:39:01 -0700, psmest <psmest_at_primenet.com> wrote:
> >
> >>Is there any known method for calling a DLL from a stored procedure????
> >>I haven't been able to locate any information on this, so I'm guessing
> >>that this isn't physically possible.
> >>
> >>Any knowledge in this area would be greatly appreciated!!!!!
> >
> >Possible in 8.x, not directly so in 7.x
  Received on Fri Feb 27 1998 - 00:00:00 CST