...

<query name="getOrderNumber">
    <retrieve>
        <statement>
            exec GetNewOrderNum @cust = {customerId}, @dept = {department} 
        </statement> 
    </retrieve> 
</query>

If you need to call this stored procedure from a business rule you can pass the form data to the database connector as shown below. Note that customerId and department are the name of two controls in your form.

eval ('x=' + http.get('http://localhost:8082/database/BIRT/getOrderNumber?cust=' + 
	customerId.value + '&dept=' + department.value));

Auto Create Rows

You can set the attribute autocreate in a query element.

...