[Dbix-class] Yet Another DBIX:Class and Stored Procedures Question

[Karen Hoofnagle]

> I've been trying to come up with a consistent and comfortable  
> approach to dealing with a large number of complex action-performing  
> stored procedures I've got sitting in my Oracle database -- things  
> with names like "Assign_customer" that perform many actions across  
> several tables and don't really belong to the customer table.  Also,  
> they return very little data. Really they return their success or  
> failure in OUT variables along with some error and state messages.
>
> The cookbook has good suggestions about how to wrap complex and  
> arbitrary sql inside a custom ResultSource, but that seems most  
> appropriate for the case where you're returning an actual result  
> set, not a couple of OUT bind variables.   Is there a design pattern  
> people have found successful for handling this? I keep thinking  
> there's got to be a more graceful way to do this than to set up a  
> dummy table (Dual or the like) and then have a custom ResultSet full  
> of subs doing raw DBI calls and returning the resulting out  
> variables as a hash.
>
> Can anyone offer up suggestions for what they've done that they're  
> happy with?  Is there a paradigm for dealing with this that's just  
> supposed to be understood and that I'm missing?
> Thanks,
> Karen
>
>
>
>