Re: Query a VARRAY
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Fri, 2 Sep 2011 06:20:55 -0700 (PDT)
Message-ID: <6b7cc106-ab93-4775-bda4-ca8e4e309147_at_s2g2000prm.googlegroups.com>
On Sep 2, 6:22 am, Juerg <juerg.schaufelber..._at_tele2.ch> wrote:
> 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
Date: Fri, 2 Sep 2011 06:20:55 -0700 (PDT)
Message-ID: <6b7cc106-ab93-4775-bda4-ca8e4e309147_at_s2g2000prm.googlegroups.com>
On Sep 2, 6:22 am, Juerg <juerg.schaufelber..._at_tele2.ch> wrote:
> 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
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 -- Received on Fri Sep 02 2011 - 08:20:55 CDT