Null and empty string

From: Marko Mikulicic <nospam_at_spamseul.org>
Date: Tue, 04 Sep 2001 15:15:22 +0228
Message-ID: <9n2i8n$fb3b$1@as201.hinet.hr>

Hello,

I'm new to oracle.
I don't understand how can empty strings be the same as NULL. I don't know if it is an ansi sql standard or not but I thought that logically (like in postgresql) empy strings are different objects from "null".

However, I have the following problem:
Because of an unknown ORA-32255 error I can't read rows wich contain null clob values.
But I need the possibility of empty fields (null or empty is not important for me in this case). But when I set a value to '' it is interpreted as a "null" and the ORA-32255 error comes back.

Does anyone know a way around this ?
Thanks,

Marko Mikulicic

PS:
I'm using a wrapper library around OCI (a clone of EOF 1.0 called gstep-db that works well.) Received on Tue Sep 04 2001 - 07:47:22 CDT