Hi,

--I am trying to update the date in oracle9i through hibernate.
--The date string that i am using to update the
DB through Hibernate is 01-AUG-2005.
--This works fine with sql DB.But with oracle9i it throws the exception

ORA-01847: day of month must be between 1 and last day of month

Please help me out asap.

Just a suggestion....it might work better to ..
a. converting string to date in your own code using a SimpleDateFormatter
b. then set the value as a Date object instead of String object.

You can set nls_date_format in oracle init.ora file
For example, if you can set string like '01-AUG-2005' set
nls_date_formt to 'dd-mon-yyyy'

regards