| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
