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
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 637313Received on Thu Oct 10 1996 - 00:00:00 CEST