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

Tony wrote:

<snip>
> The problem is that the resulting laborcode in labtrans is always 16
> characters long. If the selected laborcode from labor is less (i.e. JEDRF)
> then it padds the field with spaces to equal 16 characters. Is this a
> function of the embedded sql in C? Or of Oracle

I think it's Oracle being helpful. There's a init<..>.ora parameter called blank_trimming which may help - don't know if it affects Pro*C or not. Try adding

blank_trimming = TRUE

to tour ini.ora file.

HTH Jamie Keir

Ps. You could always try something like "Name[strlen(Name)] = 0;" in C. Received on Wed Apr 08 1998 - 10:47:07 CDT