9.5 webMethods Select JDBC Adapter Issue with the TIMESTAMP

Krishna – Any luck on this issue.


I have checked with the DBA. They came back saying this procedure has been declared as table type so it cant be called directly in SQL developer instead they need to write a program to run the test.

OK can’t they alter the data type and make it available in your procedure to work ?


I agree with RMG. You request them to support you for win-win.


I think I am replying late, but i too faced the same issue couple of times and after some trail and errors i got it fixed .

From some of the latest versions, timestamp has been removed from the datatypes(seems to be)

Solution : fetch your values from DB as an object . You will get the date with timestamp as is in the database.

Hope it will be helpful for some one.