Jun 27 2008, 08:12 AM
I am developing an application that generates queries at run time. I am using OTL(Oracle template library) for database related operations. Now the problem is that when application generates a select query and if the table has a column which has timestamp datatype then the application throws an exception (this exception contains empty message). Application generates insert and update query fine. Please help me in this.
Jun 27 2008, 05:25 PM
What is the problem? Fix the application or alter the datatype.
Jun 28 2008, 04:30 AM
Problem is when i generate the select statement OTL throws exception (in this exception the message is empty). I can't change the datatype but i am sure the problem is due to timestamp. I have changed the datatype just for sake of the testing, select query generated executed successfully. Is that driver problem or OTL ? Waiting for reply.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here