Home » Server Options » Spatial » insert big geometry
insert big geometry [message #111839] Mon, 21 March 2005 05:38
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"

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

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

Current Time: Mon Mar 20 10:27:07 CDT 2023