Re: Wanted: Sample of array-fetch using OCI8 (non Pro*C)

From: rshell <rshell_at_ukonline.co.uk>
Date: Thu, 30 May 2002 23:36:45 +0000
Message-Id: <3cf6a90c$0$10793$afc38c87@news.ukonline.co.uk>

Sven C. Koehler wrote:

> Hello all!
>
> I am reading the OCI Programmer's Guide, and I am looking for examples
> that use the OCI8 to do array fetches, but so far I only found Pro*C
> examples doing array fetches. The only OCI examples I found, seem to be
> out of date, since they are using obndra().
>
> Any hints are greatly appreciated!
>
> Best regards,
>
> Sven C. Koehler

The best hint I can give in to use a good library to hide the complexity OCI8 if possible. I have switch most of our applications to the OTL template library. This make good internal uses array sizes for all operations. Wraping OCI8 into a simple streams model which is very easy to program against and works well in C++.

Check out: http://members.fortunecity.com/skuchin/home.htm

The are 100+ unit test source example to help get started.

The application code I have converted to use this improved from 120 insert/sec to about 3000+ per client. Select performed ended limited by network bandwidth in most simple cases.

Robert Shell. Received on Thu May 30 2002 - 18:36:45 CDT