Re: OCI Functions for C

From: Beverley Williams <bev_at_starfleet.bt.co.uk>
Date: 1996/10/10
Message-ID: <53ilpi$3gs_at_pheidippides.axion.bt.co.uk>#1/1


"Thierry Merlin" <T.Merlin_at_citb.bull.net> wrote:
>
 

>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 ?

Thierry,

If you have declared ename to be of datatype char(10) then I have a feeling that the rest of the space is padded out. If you declare ename to be of datatype varhar2(10) then it won't pad. HTH

-- 
Bev Williams,
Contractor,
BT Labs,
Martlesham Heath,
Ipswich.

Tel : +01473 642891
Fax : +01473 637313
Received on Thu Oct 10 1996 - 00:00:00 CEST

Original text of this message