#23 sdo_ordinate_array is not completely shown

SpatialView
open
nobody
5
2012-12-18
2006-09-07
Dave
No

When I query a geometry object, and I want to view or
copy the entire contents of the
mdsys.sdo_ordinate_array, it is not completely shown.

If you look at the example below, you can see in the
sdo_elem_info_array that there are two polygons, and
that the ordinates for the second one start at number 47.
The sdo_ordinate_array only gives the information for
the first one, adds a comma (so it seems like there is
still something) and then just closes the parenthesis.

MDSYS.SDO_GEOMETRY(2007, NULL, NULL,
MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1,47,2003,1),
MDSYS.SDO_ORDINATE_ARRAY(223188.5,198737.5,
223132.5,198776.0,
223082.5,198809.0,
223069.0,198818.0,
223063.0,198820.5,
223051.0,198827.5,
223032.0,198842.5,
223016.5,198854.5,
222997.5,198864.5,
222910.5,198809.0,
222936.5,198792.5,
223184.33,198641.58,
223245.5,198604.32,
223286.0,198579.0,
223308.0,198628.5,
223310.5,198635.0,
223296.0,198643.0,
223284.5,198648.5,
223265.5,198669.0,
223246.5,198686.0,
223226.0,198708.5,
223215.0,198719.0,
223188.5,198737.5,))

Discussion