Dwayne,
VFP can not create a callable DLL like you intend. VFP can create a COM server DLL (or EXE) that can be instantiated and called from either Oracle (I assume this is possible) or called from C++ (I'm working on an app now where VC++ is using a VFP server object). If Oracle can't create an object you'll need an interface DLL in C++ that passes the method calls onto the VFP server.
>We are building an application that uses the win32 api for event processing. The system works by calling an Oracle external procedure. Oracle requires that the external program be a DLL. To date we have written the Oracle triggers, the DLL and a test program in C++ that displays the results of the Win32 api call.