Hi everyone!
I'm very new in Thingworx, I have an Oracle Database setup as a thing, and when creating a service as a SQL Query I can see all of the tables within the database (so I have a connection) however, when I try to run a query I get the following error message:
Execute Query failed: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
Thanks in advance
Solved! Go to Solution.
Please try executing the query without semi-colon in the end.
Regards,
Himanshu
Can you please paste the query you are trying .It is because of there is some inappropriate clause in your query .
Please try executing the query without semi-colon in the end.
Regards,
Himanshu
he works, thanks so much!