First of all this is not an issue, it is a kind of consultation.
We are planning to use same Oracle-SQL queries on ActiveSpace and it is throwing issues when used Oracle specific functions like to_number, lower, upper, order by.
Is there any workaround in ActiveSpace such that I can reuse those queries in AS also.
and is there any support for ORACLE SYSDATE in AS ?
We are using SPRING JDBC to talk to AS.
I know the thing we are doing is stupid, but it is required. Appreciate your help.
First of all this is not an issue, it is a kind of consultation.
We are planning to use same Oracle-SQL queries on ActiveSpace and it is throwing issues when used Oracle specific functions like to_number, lower, upper, order by. Is there any workaround in ActiveSpace such that I can reuse those queries in AS also. and is there any support for ORACLE SYSDATE in AS ?
We are using SPRING JDBC to talk to AS. I know the thing we are doing is stupid, but it is required. Appreciate your help.