[Dbix-class] feedback/help needed on cookbook "db functions and stored procs" section

[Terrence Brannon]

Re: "Using database functions or stored procedures" (
http://search.cpan.org/~ribasushi/DBIx-Class-0.08120/lib/DBIx/Class/Manual/Cookbook.pod#Using_database_functions_or_stored_procedures
)

This section does not show how to use a stored procedure from DBIC,
only a database function. I have no idea how to handle calling the
following stored procedures and functions from DBIC:

(1) the rewards_report stored procedure
http://dev.mysql.com/doc/sakila/en/sakila.html#sakila-structure-procedures-rewards_report

It takes 2 IN args and 1 OUT arg and returns several columns

(2) the get_customer_balance function
http://dev.mysql.com/doc/sakila/en/sakila.html#sakila-structure-functions-get_customer_balance

it is called with a NOW() parm:

SELECT get_customer_balance(298,NOW());