3,490
社区成员
发帖
与我相关
我的任务
分享
OracleConnection oraConn = null;
OracleCommand oraCmd = null;
OracleParameter oraParm = null;
OracleTransaction oraTran = null;
...
// 读取图片内容
oraCmd.CommandText = "declare tmplob blob; begin dbms_lob.createtemporary(tmplob,false,0); :tmpBlob := tmplob; end;";
oraParm = new OracleParameter();
oraParm.OracleType = OracleType.Blob;
oraParm.ParameterName = "tmpBlob";
oraParm.Direction = ParameterDirection.Output;
oraCmd.Parameters.Add(oraParm);
oraParm = null;
oraCmd.ExecuteNonQuery();
OracleLob lobFileContents;
lobFileContents = (OracleLob)oraCmd.Parameters["tmpBlob"].Value;
lobFileContents.BeginBatch(OracleLobOpenMode.ReadWrite);
// byteFileContent 为Blob类型的图片内容
lobFileContents.Write(byteFileContent,0,byteFileContent.Length);
lobFileContents.EndBatch();
oraCmd.Parameters.Clear();