Sv: Pro*C and User Exits
From: J. Wegener NOSPAM <xjw_at_xdde.xdk>
Date: Mon, 28 Jun 1999 16:13:27 +0200
Message-ID: <7l7vrn$c5d$1_at_news101.telia.com>
Date: Mon, 28 Jun 1999 16:13:27 +0200
Message-ID: <7l7vrn$c5d$1_at_news101.telia.com>
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 - 16:13:27 CEST