> > Why use to_number or to_timestamp? I assume you are using setString > in your prepared statement. In your Java code you can use setNull if > the value is null and setInt or setLong or setTimestamp if it is not. > Then you don't need the to_number or to_timestamp. You're absolutely right. I was trying to make it work with setString first cause I'm new to java and it was easier at first look. But I will take your advice. Thanks a lot for your time Ghislain Hachey >