插入Oracle大文本的问题!!!
我现在需要将超过500000字节的大文本信息更新到Oracle数据库中,我选择的字段类型是Long,存储过程如下:
procedure ResthomeDescriptionUpdate
(
ResthomeIntroduceID number,
IntroduceType Varchar2,
Description long, // 大文本
)
as
begin
update
"ResthomeIntroduce "
set
"Description "=Description,
"Type "=IntroduceType,
"Updatetime "=sysdate
where
"ResthomeIntroduceID "=ResthomeIntroduceID;
commit;
exception when others then
rollback;
end ResthomeDescriptionUpdate;
程序如下:
public int ChangeTheDataForResthomeIntroduce(int pResthomeIntroduceID,string type, string pDescription)
{
string stroePro = "common_packagebody.ResthomeDescriptionUpdate ";
OracleParameter[] param =
{
new OracleParameter( "ResthomeIntroduceID ", OracleType.Number),
new OracleParameter( "IntroduceType ", OracleType.VarChar),
new OracleParameter( "Description ", OracleType.LongVarChar),
};
param[0].Value = pResthomeIntroduceID;
param[1].Value = type;
param[2].Value = pDescription;
try
{
return OracleHelper.ExecuteNonQuery(OracleHelper.connectionStr, CommandType.StoredProcedure, stroePro, param);
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message);
}
}
现在程序出现错误:
"