Although setting the nls_date_format parameter will sort out your immediate problem, it is dangerous to rely on default date formats like that (if a session runs the code without having the date format set, the code breaks - and, of course, there are portability issues). It is better to explicitly set the date format whenever the date is used by using the to_char(sysdate, 'dd-mon-yyyy') function.

HTH

David.