ibatis-user-cs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From z...@umich.edu
Subject c# ibatis:procedure
Date Sun, 19 Feb 2006 17:30:29 GMT
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

Mime
View raw message