Re: test a date in a PL*SQL function

From: Eugenio <eugenio.spadafora_nospam_at_compaq.com>
Date: 2000/06/28
Message-ID: <8jcnch$33b$1@mailint03.im.hou.compaq.com>#1/1

You should test NULL using

if datein is NULL ...

NULL is "NOT A VALUE" and shouldn't be used with logical operator other than "is NULL"

--
be happy

Eugenio
remove _nospam from reply address

Opinions are mine and do not necessarily reflect those of my company

=======================================================
sheridan wrote in message <04157000.60863ac2_at_usw-ex0106-048.remarq.com>...


>Hi,

>I try to test if a date in parameter (IN) of one function.

>I've already tested with TO_CHAR (datein), LENGTH (TO_CHAR(datein)) but

>it does not work. It's bizarre but when you reference an empty

>parameter (a date in my case) PL*SQL doesn't understand and skip the

>line command.

>Thank you for help !

>

>

>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network

 *


>The fastest and easiest way to search and participate in Usenet - Free!

>

Received on Wed Jun 28 2000 - 00:00:00 CDT