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?

Report message to a moderator

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;
/

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 05 20:29:41 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.