input buffer limit causing crashes in Pro*C
Date: Tue, 21 Apr 1998 12:01:24 -0400
Message-ID: <353CC2D4.10502D47_at_lucent.com>
Greetings,
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-4790Received on Tue Apr 21 1998 - 18:01:24 CEST