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()); _______________________________________________ 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/[email protected]
