Help - Search - Members - Calendar
Full Version: TimeStamp in select
Oracle DBA Forums > Oracle > Oracle Forum
AsifIshaq
Hi All,
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.

Thanks,

Asif
SteveC
What is the problem? Fix the application or alter the datatype.
AsifIshaq
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.


Thanks,
Asif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.