I have a native sql query to a oracle database, but i don't get any result. Here is the code:


String query="SELECT {NSIL_CORE.*} FROM {NSIL_CORE} WHERE SDO_RELATE(IGEOLO_SDO, mdsys.sdo_geometry(2003,8307, NULL, mdsys.sdo_elem_info_array(1,1003,1), mdsys.sdo_ordinate_array(0.0,100.0 , 0.0,0.0 , 100.0,0.0 , 100.0,100.0, 0.0,100.0)), 'mask=INSIDE+COVEREDBY querytype=WINDOW') = 'TRUE'";

List result=session.createSQLQuery(query).addEntity("NSIL_CORE", Nsil_core.class).list();


Are there any brackets missing?
Thanks for help!