According to this snippet from SqlMap.xsd:
<xs:element name="sqlMap">
<xs:complexType>
<xs:sequence>
<xs:element ref="alias" minOccurs="0"/>
<xs:element ref="cacheModels" minOccurs="0"/>
<xs:element ref="resultMaps" minOccurs="0"/>
<xs:element ref="statements" minOccurs="0" />
<xs:element ref="parameterMaps" minOccurs="0"/>
</xs:sequence>
<xs:attribute name="namespace" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
try putting your parameterMaps node after the statements node.
--- [EMAIL PROTECTED] wrote:
> 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
>
