oraperl: inserting null dates

From: David Thornewill von Essen <ttg242_at_newton.sps.mot.com>
Date: Sun, 10 Oct 1993 20:52:11 GMT
Message-ID: <1993Oct10.205211.14580_at_newsgate.sps.mot.com>


The oraperl man page reveals that &ora_bind replaces empty values with a blank. If you want to insert null values into date columns this creates a problem since the conversion routines complain that the blank isn't a valid date.

Has anyone found an elegant workaround other than inserting a dummy date and then updating all rows with col = NULL where col = dummy date.

Regards,
David TvE

---

+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
David Thornewill von Essen Sr. Systems Analyst Motorola ASIC Division I don't speak for Mot. Chandler, AZ-85224 fax: (602) 814-4451 email: ttg242_at_email.sps.mot.com tel: (602) 814-4395
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Received on Sun Oct 10 1993 - 21:52:11 CET

Original text of this message