Home » Server Options » Spatial » how to solve ORA-0939 (oracle 10g)
how to solve ORA-0939 [message #442687] Wed, 10 February 2010 00:06 Go to next message
sueazri
Messages: 2
Registered: February 2010
Location: malaysia
Junior Member

did anyone know how to solve this problem? i need to store more than 2000 points into oracle dbms. but oracle allowed only 999 points. do you have any other way so i can store 2000 points into oracle?
Re: how to solve ORA-0939 [message #451654 is a reply to message #442687] Fri, 16 April 2010 00:23 Go to previous message
MSAM123
Messages: 29
Registered: June 2007
Junior Member
INSERT is limited to 999 values in SDO_ORDINATES field when using the SDO_GEOMETRY constructor directly.
So instead use host variable for the geometry object.

CREATE OR REPLACE PROCEDURE
  INSERT_GEOM(GEOM MDSYS.SDO_GEOMETRY) IS

BEGIN
  INSERT INTO TEST_1 VALUES (GEOM); 
  COMMIT;
END;
/

Previous Topic: SDO_NN error
Next Topic: Update SDO_GEOMETRY
Goto Forum:
  


Current Time: Wed Aug 20 16:19:04 CDT 2014

Total time taken to generate the page: 0.20728 seconds