Re: Pro*C variable name lengths

     AFAIK Pro*C does nothing more than commenting out EXEC SQL statements and replacing them with OCI-like function calls. There may be an issue, but it's more probably on the compiler side. Sometimes relatively long identifiers are allowed but only the n first characters are taking into account.

Stephane Faroult
RoughSea Ltd <http://www.roughsea.com>
Konagora <http://www.konagora.com>
RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>

On 04/26/2011 04:07 PM, Adams, Matthew (GE, Appl & Light) wrote:
>
> Does anyone know where the allowable length of host variable names is
> documented for Pro*C?
>
> We've upgraded a database from 8.1.7 to 10.2.0.5 (HP-UX). After
> recompiling pro*c, developers are stating that programs are not
> behaving properly unless some variable names are shortened.
>
> Examples of what they're telling me they had to change:
>
> original variable name changed
> variable names
>
> char flt_cd_prc_clss_copics[3]; char
> flt_cd_clss_copics[3];
>
> char flt_cd_clss_grp_sls[3]; char
> flt_cd_cls_grp_sls[3];
>
> I'm finding this difficult to believe, but I suppose it's
> theoretically possible.
>
> I'd still love to find where (if anywhere) this is documented.
>
> Matt
>

--
http://www.freelists.org/webpage/oracle-l