[Dbix-class] how to execute stored procedures in DBIx::Class
Dan Dascalescu
ddascalescu+dbic at gmail.com
Tue Jan 23 06:48:03 GMT 2007
> As for SPs, we don't support ones that return multiple values/rows yet.
> You could set the resultsource to a select that retrieves from such an SP:
>
> __PACKAGE__->table('dummy')
> __PACKAGE__->result_source_instance->name(\'(select * from boardslist)');
How would one access result sets returned by a Stored Procedure that
takes parameters?
Something like:
SELECT me.name, me.salary FROM top_employees_by_some_criteria(?, ?) me
?
More information about the Dbix-class
mailing list