Home » Server Options » Spatial » insert big geometry
insert big geometry [message #111839] Mon, 21 March 2005 05:38
nsibille
Messages: 4
Registered: March 2005
Junior Member
Hi all,

I want to insert a big geometry into table but i have this message ORA-00939: too many arguments for function
I use OO4O for insert, i want to do this with program.
I try with this, but errors (problem with GEOMETRY type it's not a object) :

Dim OraSession As OraSession
Dim OraDatabase As OraDatabase
Dim OraSqlStmt As OraSqlStmt
Dim CTAB As OraParamArray
Dim GTAB As OraParamArray

Set OraSession = CreateObject("OracleInProcServer.XOraSession")
Set OraDatabase = OraSession.OpenDatabase("SIG", "TEST/TEST", 0&)

OraDatabase.ExecuteSQL ("drop table test")
OraDatabase.ExecuteSQL ("create table TEST(C VARCHAR2(50), G MDSYS.SDO_GEOMETRY)")


OraDatabase.Parameters.AddTable "C", ORAPARM_INPUT, ORATYPE_VARCHAR2, 1, 50
OraDatabase.Parameters.AddTable "G", ORAPARM_INPUT, ORATYPE_OBJECT, 1

Set CTAB = OraDatabase.Parameters("C")
Set GTAB = OraDatabase.Parameters("G")

CTAB(0) = "A"
GTAB(0) = "MDSYS.SDO_GEOMETRY(3001,NULL,MDSYS.SDO_POINT_TYPE(877932.27,165307.81,0),NULL,NULL)"

Set OraSqlStmt = OraDatabase.CreateSql("insert into test(C, G) values(:C,:G)", 0&)

Thanks
Previous Topic: Spatial Educational License?
Next Topic: Spatial analysis
Goto Forum:
  


Current Time: Thu Mar 28 07:14:14 CDT 2024