Make sure you are entering the SQL correctly into the SQL statement window.
The following is incorrect:
This will generate
ODBC Layer Error: [S1000] ==> [[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00936: missing expression]
You can see in the log the query is incorrect as it contains select twice
SELECT Statement [SELECT SELECT * FROM V_ACTDATA] is generated
The following is valid
You can also read up on the Oracle error - ORA-00936 which usually means the SQL statement is not valid.
Now that is resolved and came up with different error message. Could you also please help on this
Mon~Aug~19~05:06:33~2019~Local~~19644~Info~(1021043)~Connection has been established
Mon~Aug~19~05:06:33~2019~Local~~19644~Info~(1021044)~Starting to execute query
Mon~Aug~19~05:06:33~2019~Local~~19644~Info~(1021013)~ODBC Layer Error: ~[S1000]~ ==> ~[[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01008: not all variables bound]
Mon~Aug~19~05:06:33~2019~Local~~19644~Info~(1021014)~ODBC Layer Error: Native Error code ~
Mon~Aug~19~05:06:33~2019~Local~~19644~Error~(1021106)~Failed to Execute SQL Statement. See log for more information
Mon~Aug~19~05:06:33~2019~Local~WHGAR~AR~C27128@hotelgroup_com~19644~Warning~(1080014)~Transaction ~[ 0x185000a( 0x5d5a6699.0x4de18 ) ]~ aborted due to status ~~.
Have a search for the Oracle error as you will find the reason behind it, sounds like you are trying to include variables.
also try to simplify your query so it works and then start to build on that with more complexity, at least you will understand where the issue is.