Re: Pro*C, Dynamic SQL Method 4 and Host Arrays

Jason,

My Oracle-Data-Dumper called "dosql" uses Pro*C M4, and runs in 7.x, 8.0 and 8i with the same source code.

You can find this source code on http://www.dondorp.com/dosql.html

HTH,         Erwin

Jason Botwick wrote:
> I have an application written in Pro*C that uses Dynamic SQL Method 4 with
> host arrays. Under Oracle 7.3.x, it worked. But under Oracle 8.x, it doesn't
> work. When a statement using host arrays, built using Method 4 is run, it
> bombs out with ORA-01084, which is "invalid argument in OCI call". This
> error didn't even exist in Oracle 7.x.
> So my question is, has anyone run into this problem? If so, what did you do
> about it? I'm having a hard time debugging this, because no Oracle docs I
> can find are very specific about how to use host arrays with Method 4. So
> I'm stumped about how to figure out what the valid values are for all these
> OCI calls, if I can even figure out which one is bombing out.
> The sample programs with our release or Oracle work, but again, they don't
> use host arrays and M4.
> Does anyone know where I can get a relatively simple example in Pro*C that
> does use both, compile and runs?

-- 
Erwin Dondorp
<http://www.dondorp.com/>