Re: Q: eXt. Procs. - callbacks

A copy of this was sent to "huh" <huhhy_at_rocketmail.com> (if that email address didn't require changing) On Tue, 3 Aug 1999 12:38:04 +0200, you wrote:

>Hi,
>
>I would like to know more about eXternal Procedures.
>I'm mainly interested in XPs which are able to manipulate
>data in ORACLE using SQL interface - callbacks.
>
>My XP's C prototype have to contain additional CONTEXT param
>(for OCI calls it is of OCIExtProcContext datatype).
>
>Are XP callbacks supported by ODBC? (PLEASE, PLEASE DON'T SAY: NOPE)

Sorry, the answer is No.

In Oracle8.0, extprocs that do callbacks must use OCI. In Oracle8i, release 8.1, they may use either OCI or Pro*C.

>If so, what is the ODBC counterpart to ::OCIExtProcGetEnv function?
>Or is it possible either to convert ::OCIExtProcGetEnv's output params
>to ODBC handles (henv, hdbc) or build (somehow) an ODBC connection string?
>
>TIA
--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Aug 03 1999 - 10:48:32 CDT