OCI, Stored Procedure and OCIBindByName

From: Corne Brouwers <corne_at_euronet.nl>
Date: Wed, 28 Apr 1999 17:28:53 +0200
Message-ID: <7g79n9$5in$1@zonnetje.NL.net>

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 Wed Apr 28 1999 - 10:28:53 CDT