描误信息: intemal Error 堆钱信息: at 0raclelntemal.TTC.TTCExecuteSal.ReceiveExecuteResponse

[kaizhou92]

使用ORACLE 数据库
变更表结构（或者修改视图），新增，删除字段后，查询数据时，会报错，过一会儿就不会出现这个问题

改结构后的几秒内会出现问题，之后就没这个问题了，业务场景是通过改视图动态返回数据

描误信息: intemal Error 堆钱信息: at 0raclelntemal.TTC.TTCExecuteSal.ReceiveExecuteResponse(Accessor1& defineAccessors,Accessor
bindAccessors, Boolean bHasRetumingParams, SQLMetaData& salMetaData, SalStatementType statementType, Int64
noOfRowsFetchedLastTime. nt32 no0fRowsToFetch Int32& no0fRowsFetched. 1nt64& quervld, Int32 longFetchSize, Int64
dlientlntal loBFetchSize.nt64 inita lOBFetchSize, nt64 initialJsONFetchSize. nt641 scnFromExecution.Boolean bAlinputBinds. Int32
arrayBindCount. DataUnmarshaller& dataUnmarshaller. MarshalBindParameterValueHelper& marshalBindParamsHelper. Int6418
(OWSAFfectedByArrayBind.Boolean bDefineDone, Boolean& bMorethanOneRowAfectedByDmWithRetClause, List 1& implicitRsList, Boolear
hl OBArrayFetchReaured at Oraclelnternal.servicebiects OracleCommand mpl.ExecuteReader String commandtext
OracleParameterCollection paramColl. CommandType commandType.
OracleConnectionlmpl connectionlmpl. OracleDataReaderlmpl& rdrlmpl.
nt32 lonaFetchsize. Int64 clientinitiaLOBFs.OracleDependencylmpl orclDependencylmpl.
Int641 scnForExecution.Int641& scnFromExecution
DracleParameterColection& bindByositionParamCol. oolean& bBindParamPresent. Int64& intemallnitiall 0BFS. Int64 intemalnitialJsoNFS
DracleException& exceptionForArayBindDM.. OracleConnection connection. Enumerable 1 adranarsedStmt. Boolean isDescribeOnly.
oolean isFromEF) at OracleManacedDataA ccess Client OracleCommand.ExecuteReader/Boolean reauery. Boolean filReouest
ommandBenavior behavor at Oracle ManagedDataAccess Client OraceCommand.ExecuteDbDataeader CommandBehavior behavior at
ivstem.Data Common.DbCommand Svstem.Data.DbCommand.ExecuteReader/CommandBehavior behavior a

Microsoft AsoNetCore Mvc nfrastructure ActionMeihodExecutor SyncObiectResuliExecutor. Execute(ActionResutvpeMapper maoer
ObiectMethodExecutor executor, Obiect controller. Obiecti arouments at Microsof AsoNetCore Mwc Infrastructure ControllerA ction'nvoker
ounedl12 (Controlleractionlnwoker
elnwokeactionllethodaswncsg
inwoker) at

[DotNetNext]

Oracle.ManagedDataAccess.Core 修改表结构存很大问题，只有将SQL随机加入一串注释才能解决这个问题
另外 视图中不能 * 一定要有明确字段 ，如果表修改那么视图中如果用了*必须重新创建引用的视图

[kaizhou92]

Oracle.ManagedDataAccess.Core 修改表结构存很大问题，只有将SQL随机加入一串注释才能解决这个问题 另外 视图中不能 * 一定要有明确字段 ，如果表修改那么视图中如果用了*必须重新创建引用的视图

之前在用[Dapper]的时候也是用的Oracle.ManagedDataAccess.Core没什么问题，我在想是不是[SqlSugar]存在缓存？

[DotNetNext]

sqlsugar没有缓存，如果你还有疑问可以写个DEMO， dapper和sqlsuagr各写一个能够重现你说的问题

[DotNetNext]

长时间未回复，还有问题发新 issues