Pro*C date question

I am trying to do a select statement in proc with a variable date. My statement works fine if I hard-code the date:

EXEC SQL BEGIN DECLARE SECTION;
int sum_ship_media;
EXEC SQL END DECLARE SECTION;
main()
:
:

        EXEC SQL SELECT SUM(ITEM_SIZE) INTO :sum
	FROM REQUEST_ITEM
	WHERE TO_CHAR(SHIP_DATE,'DD-MON-YY')= '01-NOV-94';

but the following always returns 0 in sum: EXEC SQL BEGIN DECLARE SECTION;
int sum_ship_media;
VARCHAR proc_date[10];
EXEC SQL END DECLARE SECTION;
main()
:
:

strcpy ( proc_date.arr, "01-NOV-94");
proc_date.len = strlen(proc_date.arr);

        EXEC SQL SELECT SUM(ITEM_SIZE) INTO :sum
	FROM REQUEST_ITEM
	WHERE TO_CHAR(SHIP_DATE,'DD-MON-YY')= ':proc_date';

Any ideas / suggestions would be greatly appreciated

Joe Woytek
joefw_at_daac.gsfc.nasa.gov Received on Thu Dec 22 1994 - 18:40:57 CET