Re: OCI question

jmruiz_at_cicyt.es wrote in article <5qg3q7$sfn$1_at_news.rediris.es>...
> I am porting a C program that includes dynamic SQL
> (method 4) to OCI. I have several Select clauses in the
> form SELECT * FROM TABLE. With method 4 I can get the
> unknown number of columns doing the following:
>
 <snip>
>
> With OCI, I do not know how to do it in just ONE call.
> If I use odescr, I have to implement something like this:
>
> for(i=1;;i++)
> {
> odescr(cursor,i,...)
> if (error) break;
> }
>
> If this is the right way, how many internal calls to the server are
 required
> (I hope there is not need for one call for each odescr ...)?

this is indeed the only way to do it. i have once read a paper (i believe a pdf) from oracle called 'optimizing oci prog's in a client/server environment' that said that odescr would 'cache' 16 columns at a time. this means that if you select 16 columns your odescr's will only hit the dictionary once.

hth

gert

ps. i lost the pdf and don't know where i found it... Received on Tue Jul 15 1997 - 00:00:00 CEST