Sv: Pro*C and User Exits

It is possible to user Pro*C in a user exit. Note these common "pitfalls":

• By default, you share your connection to the DB with Forms. No separate login is necessary; but is is possible to open another session in the user exit
• Be very careful using DDL and commits in a user exit. You may wind up screwing up the internal state of Forms.
• The distribution issue of the Oracle binaries becomes more difficult, as you need to distribute you user exit as an additional DLL to each and every Forms client computer
• Consider, if feasible, implementing your exit as PL/SQL or by using the ORA_FFI package.

The Pro*C reference guide contains several examples. Good luck.

Cheers,
Johan

Scott Quinn <scott_at_pacifictech.com.au> skrev i en nyhedsmeddelelse:OCHd3.19$2f2.3001_at_nsw.nnrp.telstra.net...
> Hi,
>
> Are there any problems with having a user exit that uses Pro*C ?
>
> ( Environment is NT, VC 6.0, Forms 5, Oracle 8.0.5. )
>
> Regards,
>
> Scott Quinn
>
>
Received on Mon Jun 28 1999 - 09:13:27 CDT