Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> test a date in a PL*SQL function

test a date in a PL*SQL function

From: sheridan <christophe.garrigueNOchSPAM_at_nxbp.fr.invalid>
Date: 2000/06/27
Message-ID: <04157000.60863ac2@usw-ex0106-048.remarq.com>#1/1

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 !

Received on Tue Jun 27 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US