Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X
Hi
I am trying to run below against Oracle database.
var sql_query = "select sysdate from dual";
// ExecuteDynamicSelect(Query:STRING):INFOTABLE
var result = me.ExecuteDynamicSelect({
Query : sql_query
});
It gives me Invalid SQL error.
I am able to run SQL Queries and Commands.
Appreciate your help!
Thanks
Sabarish,
[context: com.thingworx.webservices.context.HttpExecutionContext@53dafe31][message: Execution error in service script [PAPPSDB_JAL FetchDDRs] : Wrapped java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement
where can I find "ExecuteDynamicSelect" service?
is it OOTB service or custom ?
that is a custom service Sabarish defined.
Thank you very much Pai!
I understand it now. Well it's very useful for Dynamic Query.
Greate~