NULLs are now always NULLs ?

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Wed, 22 Mar 2006 10:27:44 -0500
Message-ID: <1222r5l8t4qof5c@corp.supernews.com>

Hi

Question for nulls, I suppose...

If I do this:
SQL> select dump('') from dual;

DUMP

---

NULL SQL>select dump(null) from dual;

DUMP

---

NULL This is what I expect, both syntax NULL and '' represent a null value;

Then why does it make a difference here ? SQL> exec dbms_system.set_ev(100,200,10046,4,'') --> works just fine SQL> exec dbms_system.set_ev(100,200,10046,4,null) --> does not work (does not generate a trace file)

Thanks !

-- 
Syltrem
Oracle 9.2.0.5 on OpenVMS 7.3-1
http://pages.infinit.net/syltrem (OpenVMS information and help, en français)

Received on Wed Mar 22 2006 - 09:27:44 CST