Pro*C input limit bug

From: Ben Branch <benson.branch_at_lucent.com>
Date: Wed, 06 May 1998 14:13:18 -0400
Message-ID: <3550A83E.89A8882_at_lucent.com>

I have stumbled across what appears to be a bug or undocumented limit in Pro*C. Specifically, the length of the statement where I am executing a prepared statement using host variables; e.g., EXEC SQL EXECUTE :mystatement USING :var1, :var2, (etc).

If the total length of this statement exceeds a particular size, proc crashes with a core dump in vfprintf. Originally I had longer host variable names (such as "field22") and this limit occurred at 32 variables (each a field for a new record being inserted). When I shrank the names (to "f22") the limit now happens at 55 fields. This bug limits the number of fields in a record that can be handled.

Setting the ireclen option to a large number (1000) does not solve the problem.

Has anyone else seen this problem? Any workaround? My application really shouldn't have an undocumented limit on the number of fields in a record .... Alternatively, how do I report this problem to Oracle?

Platform: Solaris 2.4, 2.5
Proc*C: version 2.2.2.0.0

Thanks in advance,

Ben

-- 
Ben Branch
bensonbranch_at_lucent.com
614-860-4790

Received on Wed May 06 1998 - 20:13:18 CEST