我现在需要将超过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中测试这个存储过程也出现这个问题,请问大家这是怎么回事???
谢谢!!!