Re: Using DLL from PL/SQL outside forms

In article <55d9n9$347_at_nntp1.u.washington.edu>, Le-Chin Eugene Liu <philt_at_u.washington.edu> writes
>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.
>
Its not as simple as you might think. Not all platforms support dynamic libraries and many that do still require some kind of stub to be linked to the calling program. This means relinking your Oracle kernel! There are major support issues there for Oracle.

Cross platform portability has always been one of Oracle's major planks and they would be fooloish to give that up.

Having said that I think we might see something similar to the FORMS_FFI on the kernel soon. (Is forms FFI available for Dev/2000 on platforms other then windows?)

A better longer term solution might by some support for remote method invocation such as CORBA or ActiveX. Given the object-oriented features which are supposed to be in Oracle 8, this seems more likely
>
>
>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
>
>
 

-- 
Jim Smith