Re: Query a VARRAY

From: Juerg <juerg.schaufelberger_at_tele2.ch>
Date: Fri, 2 Sep 2011 08:00:40 -0700 (PDT)
Message-ID: <b3b4fbce-7311-4c80-b9fb-6b3a016cc8bf_at_t5g2000yqj.googlegroups.com>

> 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 Received on Fri Sep 02 2011 - 10:00:40 CDT