Re: How to pass a handle obtained from an OCI program to a Pro*C program ?

Ivan Krivobarski wrote:
>
> Hi there,
> Can anybody help me - How can I pass a handle obtained from an OCI program
> to Pro*C program ?
> In other words - how to get the Pro*C context for the session from an OCI
> connection handle.

I think it would be better if you were to think of it the other way around - using OCI calls in a Pro-C program.

Here are the steps:

To embed OCI calls in your Pro*C/C++ program, take the following steps:

1. Declare an OCI Logon Data Area (LDA) in your Pro*C/C++ program (outside the Declare Section if you precompile with MODE=ANSI). The LDA is a structure defined in the OCI header file ocidfn.h. For details, see the Programmer's Guide to the Oracle Call Interface.
2. Connect to Oracle using the embedded SQL statement CONNECT, not the OCI orlon() or onblon() calls.
3. Call the Oracle runtime library function sqllda() to set up the LDA. That way, the Pro*C Precompiler and the OCI "know" that they are working together. However, there is no sharing of Oracle cursors.