有天这样的sql语句:
insert into building(objectid,geometry) 
VALUES('1',SDO_GEOMETRY(3008,NULL,Null,SDO_ELEM_INFO_ARRAY(1,1007,1,1,1006,6,1,1003,1,16,1003,1,31,1003,1,46,1003,1,61,1003,1,76,1003,1),
SDO_ORDINATE_ARRAY(6480357.54645854,1846550.25297484,384.709626833255,6480311.29982045,1846572.95319146,376.815402517268,6480311.2998204)))
我要把6480357.54645854,1846550.25297484,384.709626833255,6480311.29982045,1846572.95319146,376.815402517268,6480311.2998204动态绑定起来。
string strQuery="into building(objectid,geometry) 
VALUES('1',SDO_GEOMETRY(3008,NULL,Null,SDO_ELEM_INFO_ARRAY(1,1007,1,1,1006,6,1,1003,1,16,1003,1,31,1003,1,46,1003,1,61,1003,1,76,1003,1),
SDO_ORDINATE_ARRAY(:geom)))";
OraclCommad commad = new OracleCommand(strQuery,_oraConnection);
OracleParameter parameter = new OracleParameter(":geom",OracleDbType.Array);
parameter.Value = doublearrya;(一个doulbe类型的数组)
command.Parameter.Add(parameter);
我执行的时候出现“绑定参数无效的错误”
我觉的问题的在:geom的类型不对 不是OracleDbType.Array. varchar也不是的,因为我绑定的也不是字符型。高手帮我看看怎么解决?