<das:stored-procedure> element describes a database stored procedure. The procedure consists of a batch of queries described by a sequence of table data sources, one or more named input parameters and one or more returned values.

 

The following sample describes an sql-server stored procedure called GetEmployees.

 

 

<das:stored-procedure connection="con1" procedure-name="GetEmployees">

 

       <das:table-data-source id="ds2">

               <das:field id="fld5" name="id"/>

               <das:field id="fld6" name="name"/>

       </das:table-data-source>

 

       <das:table-data-source id="ds1">

               <das:field id="fld1" name="Id"/>

               <das:field id="fld2" name="First Name"/>

               <das:field id="fld3" name="Last Name"/>

       </das:table-data-source>

 

       <das:in-param name="@minRatingLevel" src="param1"/>

       <das:return-value name="@return-value" id="ret2"/>

 

</das:stored-procedure>

 

<das:const-function>

       <das:const-return-value id="param1" value="1" type="int"/>

</das:const-function>