Spatial (MOSC)

MOSC Banner

Group By returning ORA-22901 when using SDO_GEOMETRY

edited Dec 4, 2013 12:09PM in Spatial (MOSC) 2 commentsAnswered
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, 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center