OCIBindByName problem

[chrispy]

I am trying to run a stored procedure in Oracle to update our company's external accountancy application (Sage). The problem being is that a lot of the fields I am trying to update are not nullable but I have to insert blank values (rubbish I know). If I try to pass a bind variable which just contains spaces Oracle comes back telling me I am trying to insert a NULL value into a field that cannot be null

Any thoughts

[tha_mink]

Change the table to allow null values?

[chrispy]

Thanks for the bleedin obvious reply. However if you read my first post you will see that I am trying to write to a table that belongs to Sage (the biggest accounts software package in the UK). I tried to get them them to change all their tables but stangely enough they were not interested!!