Hello,
I like to query the SDO_ELEM_INFO of a SDO_GEOMETRY column like that:

select distinct p.geometry.sdo_elem_info from pointtable p;

Why does it not work? What's wrong?
Thanks in advance

On Sep 2, 6:22*am, Juerg <juerg.schaufelber... (AT) tele2 (DOT) ch> wrote:
You should post the actual SQL statement with the error message(s)
returned by Oracle and you should also include your full Oracle
version.

HTH -- Mark D Powell --

SQL> select comp_id, comp_name, version, status from dba_registry

COMP_ID COMP_NAME VERSION STATUS
--------- ------------------------------------ ------------ ------
EM Oracle Enterprise Manager 10.2.0.3.0 VALID
SDO Spatial 10.2.0.3.0 VALID
ORDIM Oracle interMedia 10.2.0.3.0 VALID
XDB Oracle XML Database 10.2.0.3.0 VALID
EXF Oracle Expression Filter 10.2.0.3.0 VALID
RUL Oracle Rules Manager 10.2.0.3.0 VALID
OWM Oracle Workspace Manager 10.2.0.1.0 VALID
CATALOG Oracle Database Catalog Views 10.2.0.3.0 VALID
CATPROC Oracle Database Packages and Types 10.2.0.3.0 VALID
JAVAVM JServer JAVA Virtual Machine 10.2.0.3.0 VALID
XML Oracle XDK 10.2.0.3.0 VALID
CATJAVA Oracle Database Java Packages 10.2.0.3.0 VALID
12 Zeilen ausgewählt.


SQL> select p.geometrie.sdo_elem_info from av_grenzpunkte p where
rownum < 4

GEOMETRIE.SDO_ELEM_INFO
-----------------------
1,1,1
1,1,1
1,1,1
3 Zeilen ausgewählt.

SQL> select distinct p.geometrie.sdo_elem_info from av_grenzpunkte p
ERR> select distinct p.geometrie.sdo_elem_info from av_grenzpunkte p
^ERROR
SQL execution error, ORA-00932: Inkonsistente Datentypen: - erwartet,
MDSYS.SDO_ELEM_INFO_ARRAY erhalten

Any idea?
regards
Juerg