Re: user exits in Forms 6

I know this is possible because I did it before using an LDA session.

Yeah, I plan on getting it from the userexit, passing it back to Forms, then using FFI to kick off the DLLs. This works well with LDAs, but Oracle documentation for userexits is so poor, nevermind the docs for OCI calls.

[Quoted] An example of Oracle stupidity, which cost me a week:

You can't write a userexit for Forms 6.0 with the 8.1.6 precompiler. Just [Quoted] because you have the latest version of the products apparently doesn't mean [Quoted] they are compatible. No errors here, it just doesn't work. They stated I [Quoted] must use the previous version of the pre-compiler (8.0.6) to generate the [Quoted] usere-exit. This worked.

The "clincher" is that the 8.0.6 is not certified for windows 2000....

Moral of the story is to drop Forms as quickly as possible! I've had it with the fisher-price interface, tons of bugs, lack of connectivity with the real world.

Thanks for the response!
John

"DriftWood" <drift_wood_at_my-deja.com> wrote in message news:90jaot$ek7$1_at_nnrp1.deja.com...
> This may not be possible. A user exit (as you have noted) is able to
> share the connection context with forms (and thus transaction state). A
> mechanism to do this is provided for connecting code with the
> Precompilers (such as Pro*C) and within the scope of the call into the
> Pro*C code this will hold. Trying to call external 3rd party code (or
> even the Windows API) DIRECTLY FROM WITHIN FORMS is handled through the
> Foriegn Function Interface (Ora_FFI) which does NOT share the
> connection context.
>
> My gut instinct for the best way to make this work would be to suggest
> exactly what it sounds like you are trying -- writing a USER exit that
> then (from the C/C++ side) calls the Delphi code/DLLs.
>
> Big caveat here though, you will still need to control the transaction
> handling from within the C/C++ code as there will be no way to pass the
> connection information off to the Delphi code in any form that it could
> reasonably use, but you could invoke code in the Delphi DLLs from the
> C/C++ side.
>
> I don't know enough about Delphi to comment on that part of it, but the
> only mechanisms that I am aware of for getting the Forms connection
> information are built into the Precompilers and their libraries.
>
> --
> -cheers
> DW
> --------------------------------------------------------------------
> "It is a kind of good deed to say well; and yet words are not deeds.
> -William Shakespeare"
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Dec 06 2000 - 13:09:43 CET