Re: OCI (8.1.6) documentation? (for a C++ programmer)

From: Peter Vos <peter.vos_at_dns.be>
Date: Tue, 24 Jun 2003 09:04:52 +0200
Message-Id: <pan.2003.06.24.07.04.52.170758@dns.be>

On Mon, 23 Jun 2003 13:58:36 +0000, Brian Peasland wrote:

> OCI might be more than you need. Have you looked at using Pro*C instead?
> You can write "cleaner" code without getting bogged down in all the OCI
> details. 

I'm working on a piece of existing code, which uses OCI calls exclusively, but which has some problems. The decision to use OCI was made because of performance (is it really faster than Pro*C?)
The type of documentation I am looking for, is to see why it makes OCI calls the way it does - which is in some ways a little different from the examples in Oracle's documentation: that does give an overview of OCI calls, and some examples, but I havent't found anything about why one would use multiple connections, contexts, ... and how it relates to efficiency.

> Just a thought,
> Brian

Thanks,
Peter.

> [original message:]
> 
> Peter Vos wrote:

>>
>> Hello,
>>
>> At the moment, I have the Programmer's guide from Oracle,
>> which describes all that's inside OCI, but fails (at least
>> for me) to explain how to use it efficiently.
>> I have an application that stores a lot of queries, and
>> executes them on demand. My questions are about when to
>> prepare what statements, how to best use contexts and
>> connections (and how not to use them - because there seem
>> to be some bugs around),... and I would also like to know
>> how to check what's really going on? (Maybe I prepare all
>> statements, but don't get any extra performance - how do
>> I check what Oracle does behind the scenes,...)
>>
>> Can anybody point me to a good book about OCI, or online
>> documentation? Maybe even hints about using some of the
>> existing C++ wrappers instead?
>>
>> Thanks,
>> Peter.
Received on Tue Jun 24 2003 - 02:04:52 CDT