Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ProC fills varchar2 with blanks ???

ProC fills varchar2 with blanks ???

From: Bas Ven <ven_at_ats.nld.alcatel.nl>
Date: 1997/06/26
Message-ID: <33B26859.7628@ats.nld.alcatel.nl>#1/1

I declared a column as follows:
name varchar2(128)
and added a name to it : 'Bas'.

When I get into sqlplus and retrieve the value of this column it displays is correctly -Bas- (no trailing spaces).

When I fetch the same column using ProC, my C variable (declared as char name[128], initialized with: for (i=0;i<128;i++) name[i]=0; ) is filled with trailing spaces!

Is this a ProC 'feature' or is it possible to tell ProC not to do this by setting some variable ?

-- 

-----------------------------------------------------------------
J.B. Ven | Alcatel Telecom Nederland Phone: +31 (70) 3079130 | P.O. Box 3292 Fax: +31 (70) 3079191 | NL-2280 GG Rijswijk Work: mailto:ven_at_ats.nld.alcatel.nl | The Netherlands Home: mailto:basven_at_xs4all.nl |
-----------------------------------------------------------------
Received on Thu Jun 26 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US