我现在需要将超过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);
}
}现在程序出现错误:
"unimplemented or unreasonable conversion requested"我在PL/SQL中测试这个存储过程也出现这个问题,请问大家这是怎么回事???
谢谢!!!
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);
}
}现在程序出现错误:
"unimplemented or unreasonable conversion requested"我在PL/SQL中测试这个存储过程也出现这个问题,请问大家这是怎么回事???
谢谢!!!
解决方案 »
- 返回上一页使用Request.UrlReferrer中文乱码问题
- 让字段绑定到table的一个单元格
- 跪求GridView控件中的RowCommand事件的使用方法(孟子等大人们进啊,再解决不了我就失业了)
- 应邀赴宴,作为男人不会喝酒(或则因身体原因,医生不准喝酒)在酒席上怎样应酬新老朋友呢?
- 关于DataList 绑定数据后对LinkButton控件属性的设置问题
- asp.net4.0发送smtp邮件出错
- 自定义服务器控件类型不兼容问题菜鸟求助
- 请问在下面的程序中如何将对象引用设置到对象的实例
- asp.net中怎么用嵌套做商品筛选功能,新人学习。请高手给个代码瞧瞧
- 问题请教...急....
- 不知怎样写这个sql
- 用户控件问题,在先等,哥哥姐姐们帮忙啊
8i以上可以使用clob
ref:http://msdn2.microsoft.com/zh-cn/library/cydxhzhz(vs.80).aspx