Re: [Q] Blank problem in Pro*C

Use the "VARCHAR" C datatype instead of char. When a value is fetched into the 'arr' component of the structure, Oracle sets the 'len' component to the length of the string.

e.g.

        v_name VARCHAR[11];     /* declare 10 + 1 for NULL */


        ...

        EXEC SQL FETCH ... INTO :v_name;


        ...

        v_name.arr[v_name.len] = '\0';  /* Null terminate */


        ...

        printf("v_name is %s\n", v_name.arr);

-- 
Ian Funnell                  ian_at_icf0.demon.co.uk