Re: NULL and zero length strings ?

From: Zvonimir Alaber <zalaber_at_retailers.hr>
Date: Mon, 26 Jul 1999 09:47:25 +0200
Message-ID: <7nh3sp$ft5$1@as102.tel.hr>

Hi Paolo !
You have to write Database Pre-Insert Trigger for a table like this:

BEGIN
IF INSERTING THEN
:new.stda_marcd := NVL(:new.stda_marcd, ' '); :new.stda_aart := NVL(:new.stda_aart, ' '); END IF;
END; I have one table Artikel with 2 columns: stda_marcd and stda_aart. This coluumns have either some value or blanks (not NULL).

Paolo Bormida <bormidap_at_tin.it> wrote in message news:7mvku2$18m6$1_at_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 26 1999 - 02:47:25 CDT