问题描述
xml文件<?xmlversion="1.0"encoding="utf-8"?><sqlMapnamespace="Maps"xmlns="http://ibatis.apache.org/mapping"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><alias><!--类的别名--><typeAliasalias="UserInfo"type="WebApplication1.Model.UserModel"/></alias><statements><parameterTypeid="RoomStatusParameters"class="Hashtable"><parameterproperty="ORDERID"jdbcType="VARCHAR"javaType="String"mode="IN"/><parameterproperty="ITEMID"jdbcType="VARCHAR"javaType="String"mode="IN"/><parameterproperty="OPERID"jdbcType="VARCHAR"javaType="String"mode="IN"/><parameterproperty="EXECDEPTID"jdbcType="VARCHAR"javaType="String"mode="IN"/><parameterproperty="EXECTIME"jdbcType="VARCHAR"javaType="String"mode="IN"/><parameterproperty="ECODE"jdbcType="INTEGER"javaType="Integer"mode="OUT"/><parameterproperty="EMSG"jdbcType="VARCHAR"javaType="String"mode="OUT"/></parameterType><!--parameterType--><procedureid="EditRoomStatus"parameterType="RoomStatusParameters">{callprc_pacs_commitexecinpatient(?,?,?,?,?,?,?)}</procedure></statements></sqlMap>存储过程createorreplaceprocedureprc_pacs_CommitExecInpatient(orderIDinvarchar2,--HISSheetIDitemIDinvarchar2,--ProjectIDoperIDinvarchar2,--操作员工号execDeptIDinvarchar2,--执行科室编码execTimeinvarchar2,--执行时间yyyy-MM-ddhh24:mi:ssecodeoutinteger,emsgoutvarchar2)isbeginecode:=1;--执行成功返回1emsg:='神经病';endprc_pacs_CommitExecInpatient;捕捉到IBatisNet.Common.Exceptions.IBatisNetExceptionMessage=Couldnotretrieveparametersforthestoreprocedurenamed{callprc_pacs_commitexecinpatient(?,?,?,?,?,?,?)}Source=IBatisNet.CommonStackTrace:在IBatisNet.Common.Utilities.DBHelperParameterCache.DeriveParameters(IDbProviderprovider,IDbCommandcommand)在IBatisNet.Common.Utilities.DBHelperParameterCache.InternalDiscoverSpParameterSet(IDalSessionsession,StringspName,BooleanincludeReturnValueParameter)在IBatisNet.Common.Utilities.DBHelperParameterCache.DiscoverSpParameterSet(IDalSessionsession,StringspName,BooleanincludeReturnValueParameter)在IBatisNet.Common.Utilities.DBHelperParameterCache.GetSpParameterSet(IDalSessionsession,StringspName,BooleanincludeReturnValueParameter)在IBatisNet.Common.Utilities.DBHelperParameterCache.GetSpParameterSet(IDalSessionsession,StringspName)在IBatisNet.DataMapper.Configuration.Statements.PreparedStatementFactory.DiscoverParameter(ISqlMapSessionsession)在IBatisNet.DataMapper.Configuration.Statements.PreparedStatementFactory.Prepare()在IBatisNet.DataMapper.Configuration.Sql.Static.ProcedureSql.BuildPreparedStatement(ISqlMapSessionsession,RequestScoperequest,StringcommandText)在IBatisNet.DataMapper.Configuration.Sql.Static.ProcedureSql.GetRequestScope(IMappedStatementmappedStatement,ObjectparameterObject,ISqlMapSessionsession)在IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForObject(ISqlMapSessionsession,ObjectparameterObject,ObjectresultObject)在IBatisNet.DataMapper.MappedStatements.MappedStatement.ExecuteQueryForObject(ISqlMapSessionsession,ObjectparameterObject)在IBatisNet.DataMapper.SqlMapper.QueryForObject(StringstatementName,ObjectparameterObject)在WebApplication1.Service.HisService.UserInfoService.updateMFundByProcedure()位置E:testibatisWebApplication1WebApplication1ServiceHisServiceUserInfoService.cs:行号44InnerException:System.Reflection.TargetInvocationExceptionMessage=调用的目标发生了异常。Source=mscorlibStackTrace:在System.RuntimeMethodHandle._InvokeMethodFast(Objecttarget,Object[]arguments,SignatureStruct&sig,MethodAttributesmethodAttributes,RuntimeTypeHandletypeOwner)在System.RuntimeMethodHandle.InvokeMethodFast(Objecttarget,Object[]arguments,Signaturesig,MethodAttributesmethodAttributes,RuntimeTypeHandletypeOwner)在System.Reflection.RuntimeMethodInfo.Invoke(Objectobj,BindingFlagsinvokeAttr,Binderbinder,Object[]parameters,CultureInfoculture,BooleanskipVisibilityChecks)在System.Reflection.RuntimeMethodInfo.Invoke(Objectobj,BindingFlagsinvokeAttr,Binderbinder,Object[]parameters,CultureInfoculture)在System.RuntimeType.InvokeMember(Stringname,BindingFlagsbindingFlags,Binderbinder,Objecttarget,Object[]providedArgs,ParameterModifier[]modifiers,CultureInfoculture,String[]namedParams)在System.Type.InvokeMember(Stringname,BindingFlagsinvokeAttr,Binderbinder,Objecttarget,Object[]args)在IBatisNet.Common.Utilities.DBHelperParameterCache.DeriveParameters(IDbProviderprovider,IDbCommandcommand)InnerException:System.Data.OracleClient.OracleExceptionMessage=ORA-00911:无效字符ORA-06512:在"SYS.DBMS_UTILITY",line114ORA-06512:在line1Source=System.Data.OracleClientErrorCode=-2146232008Code=911StackTrace:在System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandleerrorHandle,Int32rc)在System.Data.OracleClient.OracleCommand.Execute(OciStatementHandlestatementHandle,CommandBehaviorbehavior,BooleanneedRowid,OciRowidDescriptor&rowidDescriptor,ArrayList&resultParameterOrdinals)在System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(BooleanneedRowid,OciRowidDescriptor&rowidDescriptor)在System.Data.OracleClient.OracleCommand.ExecuteNonQuery()在System.Data.OracleClient.OracleCommandBuilder.ResolveName(OracleCommandcommand,StringnameToResolve,String&schema,String&packageName,String&objectName,String&dblink)在System.Data.OracleClient.OracleCommandBuilder.DeriveParametersFromStoredProcedure(OracleConnectionconnection,OracleCommandcommand)在System.Data.OracleClient.OracleCommandBuilder.DeriveParameters(OracleCommandcommand)InnerException: