[Geoserver-users] GeoServer and Oracle Locator

GeoServer GeoServer User
1

Hi,

I’m have a problem. I have a table in oracle with 4 columns, but when I try generate featureType the GeoServer read just 1 column.
Some idea?

Best Regards,

Fernando Quadro
fsquadro@anonymised.com

Receba GRÁTIS as mensagens do Messenger no seu celular quando você estiver offline. Conheça o MSN Mobile! Crie já o seu!

2

Fernando Quadro wrote:

Hi,

I'm have a problem. I have a table in oracle with 4 columns, but when I try generate featureType the GeoServer read just 1 column.
Some idea?

My best guess is that the other columns are one of the Oracle string
types that geoserver 1.7.x still does not support, such as
nchar or nvarchar2. A sql script for the creation of the table would
help in diagnosing the issue.

Cheers
Andrea

3

Hi Andrea,

The columns that dont appear are: SGRODOVIA, CDTRECHO.

The sql script is:

create table EGEOTRECHO2D
(
SGRODOVIA CHAR(6) not null,
CDTRECHO NUMBER(3) not null,
DTATUALIZA DATE,
GMTRECHO2D MDSYS.SDO_GEOMETRY
)
tablespace SIDER
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);

Some Idea?

Best Regards,

Fernando Quadro
http://www.fernandoquadro.com.br
fsquadro@anonymised.com

Date: Thu, 5 Mar 2009 15:04:39 -0500
From: aaime@anonymised.com
To: fsquadro@anonymised.com
CC: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] GeoServer and Oracle Locator

Fernando Quadro wrote:

Hi,

I’m have a problem. I have a table in oracle with 4 columns, but when I
try generate featureType the GeoServer read just 1 column.
Some idea?

My best guess is that the other columns are one of the Oracle string
types that geoserver 1.7.x still does not support, such as
nchar or nvarchar2. A sql script for the creation of the table would
help in diagnosing the issue.

Cheers
Andrea

Diversão em dobro: compartilhe fotos enquanto conversa usando o Windows Live Messenger.

4

Fernando Quadro wrote:

Hi Andrea,

The columns that dont appear are: SGRODOVIA, CDTRECHO.
The sql script is:

create table EGEOTRECHO2D
(
  SGRODOVIA CHAR(6) not null,
  CDTRECHO NUMBER(3) not null,
  DTATUALIZA DATE,
  GMTRECHO2D MDSYS.SDO_GEOMETRY
)
tablespace SIDER
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

Some Idea?

Hmmm... unsure. Which Oracle datastore and GeoServer version
are you using?

Afaik the latest nightly build of GeoServer + the Oracle NG
driver should be able to handle all of those columns:
http://gridlock.openplans.org/geoserver/1.7.x/
(pick the Marth 5 build).
I believe the CHAR column was not handled up to one week ago,
bbut the number and date one should have...

Do you have a full script (create table, registration in
metadata, index creation, a few rows of data) so that I can
double check against my local build?

Cheers
Andrea

5

Hi Andrea,

The sql script is:

–CREATE TABLE
create table EGEOTRECHO2D
(
SGRODOVIA CHAR(6) not null,
CDTRECHO NUMBER(3) not null,
DTATUALIZA DATE,
GMTRECHO2D MDSYS.SDO_GEOMETRY
)

–METADATA
insert into user_sdo_geom_metadata
(TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
values
(‘EGEOTRECHO2D’,
‘GMTRECHO2D’,
sdo_dim_array(sdo_dim_element(‘X’, 227737.932890026, 757720.019527611, 0.005),
SDO_DIM_ELEMENT(‘Y’, 6755279.99936535,7124727.00079743, 0.005)),
29192);

–DATA INSERTS
insert into egeotrecho2d (sgrodovia, cdtrecho, gmtrecho2d)values
(‘SC402’,
102,
sdo_geometry(2002,
29192,
NULL,
sdo_elem_info_array(1, 2, 1),
sdo_ordinate_array(593236.000174423,
6856399.00003553,
593228.999086416,
6856423.00054755,
593234.000302421,
6856447.00003557,
593239.000494426,
6856509.00016363,
593209.999790399,
6856570.00086768,
593207.000494396,
6856597.00067571,
593207.010734396,
6856597.06416371,
593207.645614396,
6856600.61744371,
593212.0006864,
6856625.00093174,
593213.479342402,
6856659.03971577,
593213.999534402,
6856671.00003578,
593210.347950399,
6856681.55133179,
593204.999598394,
6856697.0004198,
593165.198766357,
6856748.17277185)));

insert into egeotrecho2d
(sgrodovia, cdtrecho, gmtrecho2d)
values
(‘SC401’,
101,
sdo_geometry(2002,
29192,
NULL,
sdo_elem_info_array(1, 2, 1),
sdo_ordinate_array(593163.000238355,
6856751.00003585,
593162.969518355,
6856751.03075585,
593162.963374355,
6856751.03689985,
593055.999406255,
6856860.00073995,
593041.005998241,
6856879.99331597,
593040.999854241,
6856879.99843597,
592989.999534194,
6856911.000036,
592986.742190191,
6856912.32714,
592962.999726169,
6856922.00086801,
592934.000046142,
6856923.00131601,
592886.000046097,
6856901.00067599,
592885.752238097,
6856901.02832399,
592868.315566081,
6856902.96573199,
592868.00017408,
6856903.00054799)));

insert into egeotrecho2d
(sgrodovia, cdtrecho, gmtrecho2d)
values
(‘SC401’,
101,
sdo_geometry(2002,
29192,
NULL,
sdo_elem_info_array(1, 2, 1),
sdo_ordinate_array(592867.47076608,
6856903.38249999,
592844.091822058,
6856920.21501201,
592843.000238057,
6856921.00042001,
592821.999022037,
6856980.99965207,
592761.000365981,
6857046.99952413,
592742.000045963,
6857060.00022814,
592725.508525947,
6857065.24822815,
592720.000429942,
6857067.00029215,
592711.841197935,
6857066.62960415,
592698.000813922,
6857065.99984415,
592654.999981882,
6857056.99990814,
592608.880045839,
6857041.78019612,
592555.000237789,
6857023.99946011,
592543.430061778,
6857022.00573211,
592526.001581762,
6857019.0002921,
592500.000173737)));

–CREATE INDEX

create index egeotrecho2d_sidx on egeotrecho2d(gmtrecho2d) indextype is mdsys.spatial_index;

Best Regards,

Fernando Quadro
http://www.fernandoquadro.com.br
fsquadro@anonymised.com

Date: Thu, 5 Mar 2009 15:48:01 -0500
From: aaime@anonymised.com
To: fsquadro@anonymised.com
CC: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] GeoServer and Oracle Locator

Fernando Quadro wrote:

Hi Andrea,

The columns that dont appear are: SGRODOVIA, CDTRECHO.
The sql script is:

create table EGEOTRECHO2D
(
SGRODOVIA CHAR(6) not null,
CDTRECHO NUMBER(3) not null,
DTATUALIZA DATE,
GMTRECHO2D MDSYS.SDO_GEOMETRY
)
tablespace SIDER
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);

Some Idea?

Hmmm… unsure. Which Oracle datastore and GeoServer version
are you using?

Afaik the latest nightly build of GeoServer + the Oracle NG
driver should be able to handle all of those columns:
http://gridlock.openplans.org/geoserver/1.7.x/
(pick the Marth 5 build).
I believe the CHAR column was not handled up to one week ago,
bbut the number and date one should have…

Do you have a full script (create table, registration in
metadata, index creation, a few rows of data) so that I can
double check against my local build?

Cheers
Andrea

Conheça já o Windows Live Spaces, o site de relacionamentos do Messenger! Crie já o seu!

6

Fernando Quadro wrote:

Hi Andrea,

The sql script is:

Hi,
tried out your script with GeoServer 1.7.x (soon to become 1.7.3, basically what you get in the nightlies from March 5 onwards) plus
Oracle NG datastore and I get all the attributes of the table.
The geometry type is not reported since you did not specify
it while creating the index (the only place in Oracle in which
a geom type can be specified to my knowledge).

Photographic proof attached :wink:
Cheers
Andrea

attributes.png

7

Andrea,

What is the forecast of output in version 1.7.3?

Best regards,

Fernando Quadro
fsquadro@anonymised.com

Date: Thu, 5 Mar 2009 17:26:26 -0500
From: aaime@anonymised.com
To: fsquadro@anonymised.com
CC: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] GeoServer and Oracle Locator

Fernando Quadro wrote:

Hi Andrea,

The sql script is:

Hi,
tried out your script with GeoServer 1.7.x (soon to become 1.7.3,
basically what you get in the nightlies from March 5 onwards) plus
Oracle NG datastore and I get all the attributes of the table.
The geometry type is not reported since you did not specify
it while creating the index (the only place in Oracle in which
a geom type can be specified to my knowledge).

Photographic proof attached :wink:
Cheers
Andrea

Veja mapas e encontre as melhores rotas para fugir do trânsito com o Live Search Maps! Experimente já!

8

Fernando Quadro wrote:

Andrea,

What is the forecast of output in version 1.7.3?

You mean, you'd like to see the output of a GetFeature?
You can see if for yourself if you download and run
the nightly builds:
http://gridlock.openplans.org/geoserver/1.7.x/
(take the March 5 one, and use the oracle ng datastore).

Cheers
Andrea

9

Andrea,

Excuse-me, I want to know the date of the released (1.7.3)!
But I’ll download of nightly builds.

Best regards,

Fernando Quadro
fsquadro@anonymised.com

Date: Thu, 5 Mar 2009 19:12:12 -0500
From: aaime@anonymised.com
To: fsquadro@anonymised.com
CC: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] GeoServer and Oracle Locator

Fernando Quadro wrote:

Andrea,

What is the forecast of output in version 1.7.3?

You mean, you’d like to see the output of a GetFeature?
You can see if for yourself if you download and run
the nightly builds:
http://gridlock.openplans.org/geoserver/1.7.x/
(take the March 5 one, and use the oracle ng datastore).

Cheers
Andrea

Notícias direto do New York Times, gols do Lance, videocassetadas e muitos outros vídeos no MSN Videos! Confira já!

10

Hi Andrea,

I did the download, as you said, but failed.
I am using Oracle 10g, and I download these files:

  • geoserver-1.7.x-latest-war.zip
  • geoserver-1.7.x-030509-war.zip

The oracle plugin used was geoserver-1.7.2-oracleng-plugin.zip

Some Idea?

Best Regards,

Fernando Quadro
fsquadro@anonymised.com

From: fsquadro@anonymised.com
To: aaime@anonymised.com
Date: Thu, 5 Mar 2009 21:46:00 -0300
CC: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] GeoServer and Oracle Locator

Andrea,

Excuse-me, I want to know the date of the released (1.7.3)!
But I’ll download of nightly builds.

Best regards,

Fernando Quadro
fsquadro@anonymised.com

Date: Thu, 5 Mar 2009 19:12:12 -0500
From: aaime@anonymised.com
To: fsquadro@anonymised.com
CC: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] GeoServer and Oracle Locator

Fernando Quadro wrote:

Andrea,

What is the forecast of output in version 1.7.3?

You mean, you’d like to see the output of a GetFeature?
You can see if for yourself if you download and run
the nightly builds:
http://gridlock.openplans.org/geoserver/1.7.x/
(take the March 5 one, and use the oracle ng datastore).

Cheers
Andrea

Notícias direto do New York Times, gols do Lance, videocassetadas e muitos outros vídeos no MSN Videos! Confira já!

Diversão em dobro: compartilhe fotos enquanto conversa usando o Windows Live Messenger.

11

You have to pick that up from the -ext directories, for instance, http://gridlock.openplans.org/geoserver/1.7.x/ext-030509/

-Arne

Fernando Quadro wrote:

Hi Andrea,

I did the download, as you said, but failed.
I am using Oracle 10g, and I download these files:

- geoserver-1.7.x-latest-war.zip
- geoserver-1.7.x-030509-war.zip

The oracle plugin used was geoserver-1.7.2-oracleng-plugin.zip

Some Idea?

Best Regards,

Fernando Quadro
fsquadro@anonymised.com

------------------------------------------------------------------------
From: fsquadro@anonymised.com
To: aaime@anonymised.com
Date: Thu, 5 Mar 2009 21:46:00 -0300
CC: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] GeoServer and Oracle Locator

Andrea,

Excuse-me, I want to know the date of the released (1.7.3)!
But I'll download of nightly builds.

Best regards,

Fernando Quadro
fsquadro@anonymised.com

> Date: Thu, 5 Mar 2009 19:12:12 -0500
> From: aaime@anonymised.com
> To: fsquadro@anonymised.com
> CC: geoserver-users@lists.sourceforge.net
> Subject: Re: [Geoserver-users] GeoServer and Oracle Locator
>
> Fernando Quadro wrote:
> > Andrea,
> >
> > What is the forecast of output in version 1.7.3?
>
> You mean, you'd like to see the output of a GetFeature?
> You can see if for yourself if you download and run
> the nightly builds:
> http://gridlock.openplans.org/geoserver/1.7.x/
> (take the March 5 one, and use the oracle ng datastore).
>
> Cheers
> Andrea

------------------------------------------------------------------------
Notícias direto do New York Times, gols do Lance, videocassetadas e muitos outros vídeos no MSN Videos! Confira já! <http://video.msn.com/?mkt=pt-br&gt;
------------------------------------------------------------------------
Diversão em dobro: compartilhe fotos enquanto conversa usando o Windows Live Messenger. <http://www.microsoft.com/windows/windowslive/products/messenger.aspx&gt;
------------------------------------------------------------------------

------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
  
--
Arne Kepp
OpenGeo - http://opengeo.org
Expert service straight from the developers

12

Hi Arne,

I did the download, as you said, these files:

  • geoserver-1.7.x-030509-war.zip
  • /ext-030509/geoserver-1.7.3-SNAPSHOT-oracleng-plugin.zip

But failed. What’s wrong?

Best Regards,

Fernando Quadro
fsquadro@anonymised.com

Date: Fri, 6 Mar 2009 13:45:15 +0100
From: ak@anonymised.com
To: fsquadro@anonymised.com
CC: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] GeoServer and Oracle Locator

You have to pick that up from the -ext directories, for instance,
http://gridlock.openplans.org/geoserver/1.7.x/ext-030509/

-Arne

Fernando Quadro wrote:

Hi Andrea,

I did the download, as you said, but failed.
I am using Oracle 10g, and I download these files:

  • geoserver-1.7.x-latest-war.zip
  • geoserver-1.7.x-030509-war.zip

The oracle plugin used was geoserver-1.7.2-oracleng-plugin.zip

Some Idea?

Best Regards,

Fernando Quadro
fsquadro@anonymised.com5…

From: fsquadro@anonymised.com
To: aaime@anonymised.com
Date: Thu, 5 Mar 2009 21:46:00 -0300
CC: geoserver-users@anonymised.comts.sourceforge.net
Subject: Re: [Geoserver-users] GeoServer and Oracle Locator

Andrea,

Excuse-me, I want to know the date of the released (1.7.3)!
But I’ll download of nightly builds.

Best regards,

Fernando Quadro
fsquadro@anonymised.com

Date: Thu, 5 Mar 2009 19:12:12 -0500
From: aaime@anonymised.com
To: fsquadro@anonymised.com
CC: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] GeoServer and Oracle Locator

Fernando Quadro wrote:

Andrea,

What is the forecast of output in version 1.7.3?

You mean, you’d like to see the output of a GetFeature?
You can see if for yourself if you download and run
the nightly builds:
http://gridlock.openplans.org/geoserver/1.7.x/
(take the March 5 one, and use the oracle ng datastore).

Cheers
Andrea

Notícias direto do New York Times, gols do Lance, videocassetadas e
muitos outros vídeos no MSN Videos! Confira já!
http://video.msn.com/?mkt=pt-br

Diversão em dobro: compartilhe fotos enquanto conversa usando o
Windows Live Messenger.
http://www.microsoft.com/windows/windowslive/products/messenger.aspx

Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–
Arne Kepp
OpenGeo - http://opengeo.org
Expert service straight from the developers

Notícias direto do New York Times, gols do Lance, videocassetadas e muitos outros vídeos no MSN Videos! Confira já!

13

Fernando Quadro ha scritto:

Hi Arne,

I did the download, as you said, these files:

- geoserver-1.7.x-030509-war.zip
- /ext-030509/geoserver-1.7.3-SNAPSHOT-oracleng-plugin.zip

But failed. What's wrong?

They should work. Don't know how to help unless you provide
basic logs of what's not working for you (we need error
messages, just "does not work" does not help, I can simply
reply "it works for me", which is true, and we don't get anywhere).

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

14

Fernando Quadro ha scritto:

Andrea,

Excuse-me, I want to know the date of the released (1.7.3)!

Some day this week.
Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

15

Hi Andrea,

The only line that appears in the log is:

2009-03-09 06:52:14,070 WARN [referencing.factory] - Ambiguity between inverse flattening and semi minor axis length. Using inverse flattening.
2009-03-09 06:52:14,086 WARN [referencing.factory] - Ambiguity between inverse flattening and semi minor axis length. Using inverse flattening.

That says something?

Best Regards,

Fernando Silveira de Quadro
Fone: +55 (48) 9638-1490 / +55 (47) 9617-1375
Site: http://www.fernandoquadro.com.br
MSN: fsquadro@anonymised.com…
Skype: fernando.quadro

Date: Mon, 9 Mar 2009 11:17:40 +0100
From: aaime@anonymised.com
To: fsquadro@anonymised.com
CC: ak@anonymised.com; geoserver-users@anonymised.comeforge.net
Subject: Re: [Geoserver-users] GeoServer and Oracle Locator

Fernando Quadro ha scritto:

Hi Arne,

I did the download, as you said, these files:

  • geoserver-1.7.x-030509-war.zip
  • /ext-030509/geoserver-1.7.3-SNAPSHOT-oracleng-plugin.zip

But failed. What’s wrong?

They should work. Don’t know how to help unless you provide
basic logs of what’s not working for you (we need error
messages, just “does not work” does not help, I can simply
reply “it works for me”, which is true, and we don’t get anywhere).

Cheers
Andrea

–
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

Notícias direto do New York Times, gols do Lance, videocassetadas e muitos outros vídeos no MSN Videos! Confira já!

16

Fernando Quadro ha scritto:

Hi Andrea,

The only line that appears in the log is:

2009-03-09 06:52:14,070 WARN [referencing.factory] - Ambiguity between inverse flattening and semi minor axis length. Using inverse flattening.
2009-03-09 06:52:14,086 WARN [referencing.factory] - Ambiguity between inverse flattening and semi minor axis length. Using inverse flattening.

Nothing, this messages are issued by the referencing subsystem each time, don't worry about them.

You say it does not work. Not work how? What are you doing, and
what are the results of your actions.
What is written on the logs when you're getting the unexpected errors?

There are a few guides around in the net that detail how to effectively
report a bug:
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
https://developer.mozilla.org/en/Bug_writing_guidelines

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

17

Andrea,

When I talk to does not work, that means that the columns are still not showing up. I did the following:

  • Configure Oracle in Store; (It’s ok, don’t error message)
  • Add new featuretype (Don’t error message in log, but don’t show all columns)
  • MapPreview - It’s possible view the map in map preview.

What is curious is that on your machine worked, and same I changing the geoserver version, here don’t work.

What version of Oracle you used?

Best Regards,

Fernando Silveira de Quadro
Fone: +55 (48) 9638-1490 / +55 (47) 9617-1375
Site: http://www.fernandoquadro.com.br
MSN: fsquadro@anonymised.com
Skype: fernando.quadro

Date: Mon, 9 Mar 2009 13:25:24 +0100
From: aaime@anonymised.com
To: fsquadro@anonymised.com
CC: ak@anonymised.com; geoserver-users@anonymised.coms.sourceforge.net
Subject: Re: [Geoserver-users] GeoServer and Oracle Locator

Fernando Quadro ha scritto:

Hi Andrea,

The only line that appears in the log is:

2009-03-09 06:52:14,070 WARN [referencing.factory] - Ambiguity between
inverse flattening and semi minor axis length. Using inverse flattening.
2009-03-09 06:52:14,086 WARN [referencing.factory] - Ambiguity between
inverse flattening and semi minor axis length. Using inverse flattening.

Nothing, this messages are issued by the referencing subsystem each
time, don’t worry about them.

You say it does not work. Not work how? What are you doing, and
what are the results of your actions.
What is written on the logs when you’re getting the unexpected errors?

There are a few guides around in the net that detail how to effectively
report a bug:
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
https://developer.mozilla.org/en/Bug_writing_guidelines

Cheers
Andrea

–
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

Veja mapas e encontre as melhores rotas para fugir do trânsito com o Live Search Maps! Experimente já!

18

Fernando Quadro ha scritto:

Andrea,

When I talk to does not work, that means that the columns are still not showing up. I did the following:

- Configure Oracle in Store; (It's ok, don't error message)
- Add new featuretype (Don't error message in log, but don't show all columns)
- MapPreview - It's possible view the map in map preview.

What is curious is that on your machine worked, and same I changing the geoserver version, here don't work.
What version of Oracle you used?

I am using Oracle XE. Just to make sure, I downloaded a nightly built (the one from March 9), downloaded the oracle-ng plugin, configured
access to my database, and got the fields properly recognized.

I've attached the schema resulting from DescribeFeatureType, (it has
been formatted in a separate editor, GeoServer generates compact but not
  very readable output).

When I tried to use GetFeature I got this exception instead:

Caused by: java.lang.IllegalArgumentException: Dimension D:2 and L:0 denote Coor
diantes of 2 ordinates. This cannot be resolved withan ordinate array of length
31
         at org.geotools.data.oracle.sdo.SDO.coordinates(SDO.java:2075)
         at org.geotools.data.oracle.sdo.SDO.create(SDO.java:2296)
         at org.geotools.data.oracle.sdo.GeometryConverter.asGeometry(GeometryCon
verter.java:123)

Which seems to suggest an invalid geometry... in fact, checking, the
last geometry has 31 ordinates, and the last y ordinate seems to
be missing. Puzzling, since
select SDO_GEOM.VALIDATE_GEOMETRY(g.GMTRECHO2D, 0.005) from EGEOTRECHO2D g
retuns only "true"... apparently Oracle is not considering that geometry
broken... I wonder what it deos of the missing y, does it assume it's 0?
I have to good way to tell since XE does not have the WKT encoding
functions.

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

schema.xsd (1.44 KB)