Well i also tried what slimdave suggested ...

++++++++++++++++++++++++++++++++++++++++++++++++
SQL> insert into mydate values (to_date('7/1/1998', 'DD-MON-YYYY'));
insert into mydate values (to_date('7/1/1998', 'DD-MON-YYYY'))
*
ERROR at line 1:
ORA-01843: not a valid month

++++++++++++++++++++++++++++++++++++++++++++++++


Yes there is only one Col in this table...This is a dummy table..

Thanks
Ron