Re: Oracle OLEDB Provider & CLOB dataType / VB & ADO problem

In article <bg5isl$h8e$1_at_d03.completel.fr>, sdoussiere_at_eurocortex.fr says...
> Hello,
>
> First, I'm french so my english isn't very good
>
> I have a problem with Oracle Clob DataType. When I try to put NULL value to
> CLOB DataType with ADO, changes aren't not made.
>
> rs.open "SELECT ....", adocn, adOpenKeyset, adLockOptimistic
>
> rs.Fields("ClobField") = Null ' In this case, the Update doesn't work
>
> rs.update
> rs.Close
>
> This code works if I try to write a value which is different than Null but
> not if is equal to Null. Instead of having Null, I have the old value
> (before changes), the update of the field doesn't work.
>
>

>>First, I'm french so my english isn't very good I've always wondered why people apologize for their perfect English :)

Anyway, try Updating the field directly with SQL:

conn.Execute "UPDATE ... SET ClobField = EMPTY_CLOB() WHERE ..."

• Tom