Re: Pro*C variable name lengths
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: MATT.ADAMS@xxxxxx
- Date: Tue, 26 Apr 2011 16:33:59 +0200
Matt,
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
Other related posts:
