服务器部署项目报错ora01460,Oracle 存储过程入参为 Blob类型报：ORA-01460: 转换请求无法实施或不合理...

最新推荐文章于 2022-07-18 16:41:24 发布

weixin_39975486

最新推荐文章于 2022-07-18 16:41:24 发布

阅读量761

点赞数

文章标签：服务器部署项目报错ora01460

本文探讨了在使用SqlSugar库时，尝试通过Insert和StoredProcedure方法执行SQL的不同场景下遇到的异常堆栈。作者揭示了在执行Blob类型数据插入和存储过程调用时的代码实例，以及可能引发的错误原因和解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

异常堆栈

at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)

at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, OracleLogicalTransaction& oracleLogicalTransaction, Boolean isFromEF)

at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()

at SqlSugar.AdoProvider.ExecuteCommand(String sql, SugarParameter[] parameters) in F:\Repositories\Github\ORM\SqlSugar\SqlSugar__sunkaixuan\Src\Asp.NetCore2\SqlSeverTest\SqlSugar\Abstract\AdoProvider\AdoProvider.cs:line 297

操作实体这种是可以的：

db.Insertable(new Tbl_Blob() { Blob = Datas.Bytes }).ExecuteCommand();

这种会报错

var _pms = db.Ado.GetParameters(new

{

is_Blob = Datas.Bytes

});

db.Ado.UseStoredProcedure().ExecuteCommand(sql, _pms);