I'm facing an issue when I upgrade my ojdbc14.jar to ojdbc6.jar
data_type value for Date and Timestamp is same ie., 93 if we use ojdbc6.jar.
data_type value for Date and Timestamp is different as 91 and 93, if we use ojdbc14.jar.
My Batch job fetches the data_type of the Oracle 11g TABLE and inserts value according to the data_type value it fetches.
I have tried using ResultSetMetaData and DatabaseMetaData to get data_type value using getMetadata() method.
Is there anyway to differentiate the Date and Timestamp data_type value using ojdbc6.jar?.