[Dbix-class] Calling SQL Server 2000 stored procedures using Catalyst and DBIx::Class

[Hugh Lampert]

Hello!

I'm working with  a database that has an extensive stored procedure and
user defined function API.

I've looked over the Catalyst model and DBIx::Class documentation, and
while I've found some references to calling database functions that
purport to also apply to stored procedures, I don't really see how that
could be.  Can anyone give me a snippet of sample Catalyst code I can
use to call a SQL Server 2000 stored procedure that takes a few
parameters and returns a result set?  I would really appreciate being
able to keep the ORM and use the supplied stored procedures/UDF's.

Thanks!

-- Hugh