You need to specify a select statement, and retrieve the shape field as WKT.
Something like this:
SELECT NAME, SDO_UTIL.TO_WKTGEOMETRY(GEOM) AS point FROM NEW_TEST;
Firstly, why can not I add data from db with odbc connection? GeoQlik was doing this.
I tried your sql statement and result is negative. Sql script working in db but QlikSense did not fetch data.