Re: OCI Functions for C

Thierry Merlin wrote:
>
> Hi,
>
> I have a query like this :
> "SELECT ename FROM emp";
> I use ofen( ) to fetch one or multiple rows but I don't know the length of
> string returned.
> How I can obtain this information, in which OCI functions ?
> Example :
> Column ename (dbsize=10).
> When I fetch, data='SMITH '
> How I can obtain length=5 ?

I think you now use SQLT_CHR in your odefin call. Replace it with SQLT_STR to get a zero-terminated string back from oracle.

--
Gert Rijs
mailto:gem_at_wirehub.net    (at home)
mailto:gert.rijs_at_corp.ah.nl (at work)