Re: Wierd problem Does C or Oracle pad a host variable with spaces in embedded SQL?

Home -> Community -> Usenet -> c.d.o.server -> Re: Wierd problem Does C or Oracle pad a host variable with spaces in embedded SQL?

From: Keith Boulton <boulkenospam_at_globalnet.co.uk>
Date: Tue, 14 Apr 1998 08:07:19 GMT
Message-ID: <353316a4.1495727@read.news.global.net.uk>

On Tue, 14 Apr 1998 00:12:45 -0700, Michael Krolewski <vandra_at_u.washington.edu> wrote:

>Actually it is highly unlikely that Oracle would automatically pad a variable.
>However if the source : select laborcode ... is a char(16) then the value
>would alway be padded. Ansi standard / Version 7 code will by default
>use the char data type, not varchar2. You need to explicitly select varchar2.
>

I would suggest you read the datatypes section of the Pro*C manual, where it discusses at great length the circumstances under which input and output host variables are blank-padded. Received on Tue Apr 14 1998 - 03:07:19 CDT