Home > Net >  C # the datatable as parameters, call the oracle stored procedure.
C # the datatable as parameters, call the oracle stored procedure.

Time:09-29

 DBOracleOperate oracleOperate=null; 
OracleOperate=new DBOracleOperate (" kcstationstatus ", new OracleConnection (oracleconn));
OracleParameter oracleParaemter=new OracleParameter ();
OracleParaemter. ParameterName=@ "kcstationstatusList";
OracleParaemter. Value=https://bbs.csdn.net/topics/dicTable [" kcstationstatus "];
OracleParaemter. CollectionType=OracleCollectionType. PLSQLAssociativeArray;
OracleParaemter. Direction=ParameterDirection. Input;
OracleOperate. ExecuteStored (" kcstationstatus_pro ", null);




But the execution to oracleParaemter. The Value assignment, the exception error "Value is beyond the scope of expectations,"

CodePudding user response:

OracleOperate. ExecuteStored (" kcstationstatus_pro ", null); On the parameters of useless
  •  Tags:  
  • C#
  • Related