Hello everyone
For some reasons I must use SP with NH(v 2.1.0.1), and I have some issues about this:
1.- In many posts says that I have to re-write the SP in the map file, Is it necesary?
2.- How to return a scalar result? The <return-scalar> looks good but have a column property and my result doesn't had a rowtitle, is rowtitle mandatory for this tag?
3.- How to return a list result? It means, rows from many tables.
3.- I wanna create a Repository only for execute my SPs, is it possible? and one map file?

Greetings
Xavier

<class name="MenuDetails" >
<id name="moduleID" />
<property name="moduleDesc" />
<property name="messageKey"/>
<property name="messageAction"/>
</class>


<sql-query name="<name tobe refered from app>" callable="true">
<return alias="menuDetails" class="MenuDetails">
<return-property name="moduleID" column="moduletypeid"/>
<return-property name="moduleDesc" column="moduledesc"/>
<return-property name="messageKey" column="messagekey"/>
<return-property name="messageAction" column="actionmapping"/>
</return>
{call ProcedureName(:flag,:operatorID)}
</sql-query>
Try this, Hope It will work.