OraFAQ Forum: Spatial » how to solve ORA-0939

Home » Server Options » Spatial » how to solve ORA-0939 (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to solve ORA-0939 [message #442687]

Wed, 10 February 2010 00:06

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

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.

Code: [Select all] [Show/ hide]

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 14 05:38:44 CDT 2025