Oracle can be picky about date parameters. What does your $date string look like? If it's something like 17760704 (for example), it won't fly. Try formatting it as 1776/07/04.