求助：IBatisNet无法执行Oracle存储过程，附详细信息。
0
悬赏园豆：40
[待解决问题]
System.Collections.Hashtable hashtable = new System.Collections.Hashtable(); hashtable.Add("Code", code); hashtable.Add("User", "Admin"); hashtable.Add("p_message", "none");
<parameterMaps> <parameterMap > <parameter property="Code" column="p_dc_no" dbType="VARCHAR2" direction="Input" /> <parameter property="User" column="p_user" dbType="VARCHAR2" direction="Input"/> <parameter property="p_message" column="p_message" dbType="VARCHAR2" direction="Output" /> </parameterMap>
</parameterMaps>
<procedure parameterMap="dcparam_delete"> wms.md_dc_pg.delete_dc_info </procedure>
PROCEDURE delete_dc_info ( p_dc_no IN VARCHAR2, p_user IN VARCHAR2, p_message out varchar2) IS BEGIN UPDATE md_dc SET status = 'UnActive', last_modify_code = p_user, last_modify_dt = SYSDATE WHERE dc_code = p_dc_no; p_message:='success'; END;
<provider name="oracle10.1" description="Oracle, oracle provider V10.1.0.301" enabled="false" assemblyName="Oracle.DataAccess, Version=10.1.0.301, Culture=neutral, PublicKeyToken=89b483f429c47342" connection command parameter parameterDbType parameterDbTypeProperty="OracleDbType" dataAdapter commandBuilder usePositionalParameters="true" useParameterPrefixInSql="true" useParameterPrefixInParameter="true" parameterPrefix=":" useDeriveParameters="false" allowMARS="false" />
Error Message : The parameter 'p_dc_no' does not exist in the stored procedure 'DC_PR_Delete'. Check your parameterMap.
This promble make me crazy!
How to execute a stored procedure with IBatisNet in Oracle! there is no example like this .
(Solution "MyBatis" include a Project named "MyBatis.DataMapper.SqlClient.Test",but not include Test Project of Oracle.)
please help me , i don't wanna give up ibatisnet, i like this ORM framework than NHibernate !
I Imported iBatisNet in our new project,our work couldn't continue till this promble solved!
I'm a chinese ,my English is not well,if you can speak chinese,诚心求助，敬等回复！
