Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle and COM?????
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00670214
Message ID:
00670255
Views:
14
>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.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform