Re: Oracle Foreign Function (ORA_FFI)

Ganapathy Ramesh wrote:
>
> I have been quite successful at writing Forms 4.0/4.5 userexits. I am
> now trying to use ORA_FFI built-ins to execute a very simple C DLL
> which receives two LPSTR pointers as parameters. I am simply using the
> MessageBox function in Visual C++ 1.51 to display these parameters. I
> have followed the PL/SQL wrapper example provided with Forms 4.5
> called WINSAMP.FMB/FMX. Though I am able to get upto the call, nothing
> inside the C function seems to execute. The PL/SQL constants I have
> used are C_CHAR_PTR and the starting memory location is 11265. I tried
> compiling the DLL as a large, medium and small memory model, but there
> were no results returned from the DLL. Could anyone out there please
> point out where I might be making a mistake ? Is it possible that the
> DLL I cam creating should be created like an userexit instead of an
> ordinary DLL ? Thanking you iin advance.
>
> G.V.Ramesh

Have you used the FFIGEN.FMB/FMX program (in your forms45\demos directory). FFIGEN generates a pl/sql 'wrapper' for your dll. When you first run it, it creates some tables where it stores the definitions you enter. It also creates 2 example packages (for WriteProfileString and ReadProfileString i believe).

--
Gert Rijs
mailto:gem_at_wirehub.net    (at home)
mailto:gert.rijs_at_corp.ah.nl (at work)