存
首先將文件轉化為Byte[],然後
Byte[] bytes=;//將文件轉化成二進制流
string conn="";//連接字符串
OracleConnection oraConn=new OracleConnection(conn);
if (oraConn.State != ConnectionState.Open)
{
oraConn.Open();
}
try
{
OracleCommand cmd = oraConn.CreateCommand();
cmd.CommandText = "declare xx blob; begin dbms_lob.createtemporary(xx, false, 0); :tempblob := xx; end;";
cmd.Parameters.Add(new OracleParameter("tempblob", OracleType.Blob)).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
OracleLob tempLob = (OracleLob)cmd.Parameters[0].Value;
tempLob.BeginBatch(OracleLobOpenMode.ReadWrite);
tempLob.Write(bytes, 0, bytes.Length);
tempLob.EndBatch();
cmd.Parameters.Clear();
cmd.CommandText = "updatepdf";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new OracleParameter("p_count_no", OracleType.NVarChar)).Value = strCountNo;
cmd.Parameters.Add(new OracleParameter("p_attachment", OracleType.Blob)).Value = tempLob;
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{