Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ProC fills varchar2 with blanks ???
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 ?
--Received on Thu Jun 26 1997 - 00:00:00 CDT
-----------------------------------------------------------------
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 |
-----------------------------------------------------------------
![]() |
![]() |