Here is another example of procedure call failed:
- The error occurred while loading SqlMap.
- loading procedure tag
- The error occurred in <sqlMap embedded="Resources.assocarray.xml,
AssocArray"
xmlns="http://ibatis.apache.org/dataMapper"; />.
- Check the call_ps_swap_email_address.
at
IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Build(XmlDocument
docu
ment, DataSource dataSource, Boolean useConfigFileWatcher, Boolean
isCallFromDao
)
at
IBatisNet.DataMapper.Configuration.DomSqlMapBuilder.Configure(String
resou
rce)
at AssocArray.Call_procedure.go()
Unhandled Exception: System.NullReferenceException: Object reference
not set to
an instance of an object.
at AssocArray.Call_procedure.go()
at AssocArray.Call_procedure.Main(String[] args)
Press any key to continue
...........
--------------------------------------------------
Heare is the oracle procedure:
create or replace procedure
ps_swap_email_address (inout_email_1 in out varchar2, inout_email_2 in
out varchar2)
is
tmp_e varchar2(120);
begin
tmp_e := inout_email_1;
inout_email_1 := inout_email_2;
inout_email_2 := tmp_e;
end
----------------------------------------------------
here is the sqlmap.xml file
<?xml version="1.0" encoding="UTF-8" ?>
<sqlMap namespace="assocarray" xmlns="http://ibatis.apache.org/mapping";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
<parameterMap id="swap_result">
<parameter property="email_1" direction="InputOutput"
column="inout_email_1" />
<parameter property="email_2"
direction="InputOutput" column="inout_email_2" />
</parameterMap> <statements>
<procedure id="call_ps_swap_email_address" parameterMap="swap_result">
ps_swap_email_address
</procedure>
</statements>
</sqlMap>
Could you tell me how to configure the <procedure> tags in the
sqlmap.xml file?
-Henry
