NULL and zero length strings ?

From: Paolo Bormida <bormidap_at_tin.it>
Date: Mon, 19 Jul 1999 18:49:32 +0200
Message-ID: <7mvku2$18m6$1@stargate1.inet.it>

Hi all !

I have to admit I am somewhat new to Oracle and just discovered ORACLE 7.3.4 is treating a zero length string (like this '') as NULL.

We have an application sending INSERT statements on a table with not-nullable char/varchar columns; running it against ORACLE we have a few problems..

Any idea on how to solve this problem...

Any session option to set ?

TIA

---

Paolo Bormida
Torino - Italy

---

Received on Mon Jul 19 1999 - 11:49:32 CDT