Unable to add a 500 coordinate SDO_Geometry (polygon) to a table
844160Mar 3 2011 — edited Mar 3 2011My table looks something like
CREATE TABLE myTABLE ( geomName VARCHAR2(100), myGeometry SDO_GEOMETRY);
INSERT INTO user_sdo_geom_metadata VALUES ('myTable', 'myGeometry',
MDSYS.SDO_DIM_ARRAY
(
MDSYS.SDO_DIM_ELEMENT('HANDSET_LON_DD', -180, 180, .5),
MDSYS.SDO_DIM_ELEMENT('HANDSET_LAT_DD', -90, 90, .5)
),8307
);
I can insert a simple polygon:
INSERT INTO myTable VALUES ('myTestGeometry',
SDO_GEOMETRY (2003, 8307, NULL, SDO_ELEM_INFO_ARRAY(1,1003, 1), SDO_ORDINATE_ARRAY
(
-4.51, 51.21,
-5.29, 51.44,
-5.74, 50.60,
-4.51, 51.21
) ) ) ;
However, I cannot perform the following:
INSERT INTO myTable VALUES ('GeoEllipse500',
SDO_GEOMETRY (2003, 8307, NULL, SDO_ELEM_INFO_ARRAY(1,1003, 1), SDO_ORDINATE_ARRAY
(
1.16699981689453, -0.678230285644531,
--
--a whole lot of other points (498 of them)
--
1.16699981689453, -0.678230285644531
) ) ) ;
The error:
SQL Error: ORA-00930: too many arguments for function
00939. 00000 - "to many arguments for function:
*Cause:
*Action:
If I throw away one of the middle 498 coordinates, the insert works.
Mike