Group By returning ORA-22901 when using SDO_GEOMETRY
I am trying to create a database view based on the sql statement below. The shape column has a data type of SDO_GEOMETRY. When i try to create the view or even run the sql by itself the output returns ora-22901.Can anyone point me in the right direction on how to execute a group by when using sdo_geometry?
SELECT samp.PROJECT_CODE PROJECT_CODE,
samp.SITE_NO SITE_NO,
site.NAME SITE_NAME,
samp.OBJECTID OBJECTID,
samp.SHAPE SHAPE,
aqs_uil_alib.getProjectUserList(samp.project_code) USERLIST,
samp.SITE_NO || ' (' || COUNT(samp.SAMPLE_NO) || ')' SAMPLE_ID,
0