On 25 March 2010 21:14, Terrence Brannon <[email protected]> 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/[email protected] _______________________________________________ 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]
