problem inserting DATE type.

[slimdave]

small date format error

insert into mydate values (to_date('7/1/1998', 'DD-MM-YYYY'));

... or ...

insert into mydate values (to_date('7/1/1998', 'MM-DD-YYYY'));

...depending which way round your format is.