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

[Sung Gong]

On 25 March 2010 21:14, Terrence Brannon <schemelab at gmail.com> wrote:
> 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:

Good shout, but it's shame that no progress as of today yet (28/Dec/2011)

>
> (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());
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk