Help - Setting a date field to NULL

Has anyone done setting a date field to NULL? I'm writing embeded Oracle SQL trying to set a date field to NULL without any success.

when I have:

	EXEC SQL update XX
		set XX_DATE = NULL
		where ...

The pre-compiler complains of mismatch types. However, when I enter the statement manually under sqlplus, it workes fine.

If I try:

	EXEC SQL update XX
		set XX_DATE = to_date(NULL,'YYYY/MM/DD HH24:MI:SS')
		where ...

I get a run-time error of "Input value too short for date format".

Any help is appreciated.

Jason T. Received on Tue May 20 1997 - 00:00:00 CDT