StreamWriter向Clob字段写入问题

smallquick 2009-01-06 09:54:39



        cmd.Transaction = cmd.Connection.BeginTransaction();

        cmd.CommandText = getSql();

        cmd.ExecuteNonQuery();

        cmd.CommandText = "SELECT content FROM doc_send  FOR UPDATE ";

        OracleDataReader reader = cmd.ExecuteReader();

        using (reader)

        {

            reader.Read();



            OracleLob clob = reader.GetOracleLob(0);



            StreamWriter streamWrite = new StreamWriter(clob);

            streamWrite.Write(getStr());



            OracleLob templob = CreateTempLob(cmd, clob.LobType);

            long actual = clob.CopyTo(templob);



            cmd.Transaction.Commit();

        }

我在控制台的时候通过这种方式是可以将数据写入clob字段的，但是在页面的cs文件中就不可以了，调试到
streamWrite.Write(getStr());
这一步时告诉链接已关闭，没办法访问数据库的clob字段，应该是权限问题，应该怎么解决

...全文

98 12 打赏收藏转发到动态举报

写回复

用AI写文章

12 条回复

切换为时间正序

请发表友善的回复…

发表回复

nj_1st_excellence 2009-01-07

打赏
举报

using (reader)
{
reader.Read();

OracleLob clob = reader.GetOracleLob(15);

byte[] bytes = System.Text.Encoding.Unicode.GetBytes(getStr());
clob.Write(bytes, 0, bytes.Length);

clob.Position = 0;

OracleLob templob = CreateTempLob(cmd, clob.LobType);
long actual = clob.CopyTo(templob);

cmd.Transaction.Commit();

}

建议楼主用这种方式，我用过行的通的

lovehongyun 2009-01-06

打赏
举报

对哦,dbm_lob只能处理小于32k字符

尐孑 2009-01-06

打赏
举报

mark

smallquick 2009-01-06

打赏
举报

[Quote=引用 7 楼 lovehongyun 的回复:]
C# code
string fileName = "xxxx";
string fileclob = "xxxx";
System.Data.OracleClient.OracleConnection conn;
string connString = "数据库连接串;";
conn = new OracleConnection(connString);
conn.Open();
//用参数方式写入数据库
OracleCommand myComm = conn.CreateCommand();
//定义SQL语句
string sql = "insert i…
[/Quote]

这种方法布恩那个超过32k

smallquick 2009-01-06

打赏
举报

谢谢楼上的，不过你的做法不能超过32k，而且我是文本不是byte【】

lovehongyun 2009-01-06

打赏
举报



string   fileName   =   "xxxx";   

  string   fileclob   =   "xxxx";   

  System.Data.OracleClient.OracleConnection   conn;   

  string   connString   =   "数据库连接串;";   

  conn   =   new   OracleConnection(connString);   

  conn.Open();   

  //用参数方式写入数据库   

  OracleCommand   myComm   =   conn.CreateCommand();   

  //定义SQL语句   

  string   sql   =   "insert   into   table(filename,fileclob)   "   +   

  " values(@filename,@fileclob)";   

    

  myComm.CommandText   =   sql;   

  myComm.Parameters.Add("@filename",OracleType.NVarChar).Value   =   fileName;   

  myComm.Parameters.Add("@fileclob",OracleType.Clob,System.Text.Encoding.Default.GetByteCount(fileclob)).Value   =   fileclob;   

    

  //写入数据库   

  myComm.ExecuteNonQuery();

hongqi162 2009-01-06

打赏
举报



需要先创建一个临时lob才可以写的



OracleConnection connection = new OracleConnection("server=MyServer; integrated security=yes;");

connection.Open();

OracleTransaction transaction = connection.BeginTransaction();

OracleCommand command = connection.CreateCommand();

command.Transaction = transaction;

command.CommandText = "declare xx blob; begin dbms_lob.createtemporary(xx, false, 0); :tempblob := xx; end;";

command.Parameters.Add(new OracleParameter("tempblob", OracleType.Blob)).Direction = ParameterDirection.Output;

command.ExecuteNonQuery();

OracleLob tempLob = (OracleLob)command.Parameters[0].Value;

byte[] tempbuff = new byte[10000];

tempLob.BeginBatch(OracleLobOpenMode.ReadWrite);

tempLob.Write(tempbuff,0,tempbuff.Length);

tempLob.EndBatch();

command.Parameters.Clear();

command.CommandText = "MyTable.MyProc";

command.CommandType = CommandType.StoredProcedure;  

command.Parameters.Add(new OracleParameter("ImportDoc", OracleType.Blob)).Value = tempLob;

command.ExecuteNonQuery();

transaction.Commit();

connection.Close