>Is there a way to compile some pl/sql procedures into a COM object?
>I know that in Fox you can define a class as olepublic and then compile the project, but can you make dlls from Oracle Procedures or functions?
>
>Thanks in Advance
Leroy,
PL/SQL is an interpreted Oracle only language. The engine to interpret and run the code is only found on on Oracle servers. What are you trying to accomplish by creating a protable DLL file?
What you can do is create all your PL/SQL procedures/functions/packages on the Oracle server and create a VFP COM DLL that uses SPT to execute and return results from them.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao