Re: Using DLL from PL/SQL outside forms

I don't think it will be a small action for oracle if you consider what has to happen when you execute a pl/sql block containing a dll-function call (outside Forms wich has its own pl/sql interpreter):

1. client-program (windows) sends pl/sql to server (unix, perhaps)
2. server runs pl/sql and 'sees' a dll-function
3. server has to load a dll on the client-machine and execute the function.

Perhaps you can see the problem (step 3). Even if oracle would implement it, i dont think it would perform very well...

Gert Rijs

Le-Chin Eugene Liu wrote:
>
> This kind of information has been requested over and over in the
> newsgroups but I rarely see any positive answer. My understanding
> to this question is NO, there is no way you can do this in PL/SQL
> straight forward like in MS/Sybase SQL Server. I hope someone from
> Oracle can verify this and since there are so many requests I'd
> like to propose Oracle taking actioin to include this functionality
> in the next release. I think this is just a small action for Oracle
> to take but it does imply Oracle cares users' need as a leader.
>
> In article <01bbc66f$7bf76160$c2a616cf_at_default>,
> Manish Kharod <ManishKharod_at_ij.net> wrote:
> >Is there any way to make a call to DLL from PL/SQL or SQL*PLUS? Any help
> >will be greatly appreciated. I know how to USE FFI Package from Forms 4.5
> >
> >Thanks
> >
> >Manish
Received on Fri Nov 01 1996 - 00:00:00 CET