[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