Re: OCI, Stored Procedure and OCIBindByName

Yes, the actual values are ignored if indicator is -1. If you take a look at Oracle block format (DBA Guide), you'll find out that NULL columns have size field set to 0. In case of the "" string, that is it's actual size and that's why it works with SQLT_STR. It Doesn't work with SQLT_INT because the actual size of the integer is always one
machine word (or half of it, in case of some 64 bit systems. There are different standards for 64 bit OSes and I don't
think that any of those is prevalent at the moment. Everything will change with Win NT 3000 which will be full 64
bit OS. You can expect it in the late 2999, but delays are always possible.)

Corne Brouwers wrote:

> I have a problem passing NULL-values on to a stored procedure as parameter
> values using the call OCIBindByName. It works for parameters of type
> SQLT_STR, but it doesn't for parameters of type SQLT_INT or SQLT_DAT. No
> errors are returned but the fields in the table (which I wanted to update to
> NULL) remain unchanged.
> btw: these fields are updateable and null-values are allowed
>
> Are the value-parameters ignored when the indicator parameter is -1 ?
>
> Is anyone has a solution or a working example, yes please....
>
> Corne
Received on Thu Apr 29 1999 - 13:29:42 CDT