C# SDO_GEOMETRY
2021-06-07 14:03
标签：char NPU geo tty into route man comm obj C# SDO_GEOMETRY 标签：char NPU geo tty into route man comm obj 原文地址：https://www.cnblogs.com/googlegis/p/10739510.htmlOracleParameter endGeometry = cmd.CreateParameter();
endGeometry.OracleDbType = OracleDbType.Object;
endGeometry.UdtTypeName = "MDSYS.SDO_GEOMETRY";
endGeometry.Value = routeSegment.endPointGeometry;
endGeometry.ParameterName = "P_END_GEOM";
parameter.Add(endGeometry);
cmd = new OracleCommand()
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "insert into SHAPE_SDO (CMS,POLY) values (:CMS,:POLY)";
cmd.Parameters.Clear();
cmd.ArrayBindCount = allRecord.Count;
cmd.Parameters.Add(":CMS", OracleDbType.Varchar2, CMS.ToArray(), ParameterDirection.Input);
OracleParameter oracle_SDO_Param = new OracleParameter();
oracle_SDO_Param.OracleDbType = OracleDbType.Object;
oracle_SDO_Param.UdtTypeName = "MDSYS.SDO_GEOMETRY";
oracle_SDO_Param.ParameterName = "POLY";
oracle_SDO_Param.Value = POLY.ToArray();
cmd.Parameters.Add(oracle_SDO_Param);