OCI playing nice with Pro*C QUESTION
Date: Wed, 22 Mar 2000 00:55:26 GMT
Message-ID: <2SUB4.81$846.2097_at_typhoon.tampabay.rr.com>
[Quoted] Here's the scenario:
Using Oracle 8.1x on Solaris 2.6 writing in C.
I have a set of APIs which nicely handle all connecting to the database
using OCI calls.
I have a separate function in a shared object that does updates to
a BLOB column using Pro*C.
problem:
I'd love to have an application which used the OCI APIs to connect
to the database, and still use the Pro*C library calls to do my update
of the BLOB column using the connection from OCI, but I can't find
documentation on how to accomplish this in any of Oracle's docs.
Unfortunately it appears that Pro*C won't automatically pick up the
connection established by OCI, and explicitly logging in through
Pro*C causes a second connection to be established which
invalidates the "single unit of work" idea I'm trying to maintain here.
Anyone ever tried it this way?
[Quoted] btw, I can certainly use OCI to do the BLOB updates, but for several work-related reasons I'd like to have the implementation available using Pro*C as well...
If you need any more info I'll be happy to provide it...
thx in advance
AcK Received on Wed Mar 22 2000 - 01:55:26 CET