Re: Query a VARRAY

From: Juerg <>
Date: Fri, 2 Sep 2011 08:00:40 -0700 (PDT)
Message-ID: <>

> 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     VALID
SDO       Spatial                       VALID
ORDIM     Oracle interMedia             VALID
XDB       Oracle XML Database           VALID
EXF       Oracle Expression Filter      VALID
RUL       Oracle Rules Manager          VALID
OWM       Oracle Workspace Manager      VALID
CATALOG   Oracle Database Catalog Views   VALID
CATPROC   Oracle Database Packages and Types   VALID
JAVAVM    JServer JAVA Virtual Machine   VALID
XML       Oracle XDK                    VALID
CATJAVA   Oracle Database Java Packages   VALID
12 Zeilen ausgewählt.

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



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


SQL execution error, ORA-00932: Inkonsistente Datentypen: - erwartet, MDSYS.SDO_ELEM_INFO_ARRAY erhalten

Any idea?
Juerg Received on Fri Sep 02 2011 - 10:00:40 CDT

Original text of this message