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

[Matt S Trout]

Hugh Lampert wrote:
> 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.

It's been a long time since I did Squeal Swerver in depth; could you give us a 
sketch of how you'd go about doing it either with just SQL or with plain DBI?

-- 
      Matt S Trout       Offering custom development, consultancy and support
   Technical Director    contracts for Catalyst, DBIx::Class and BAST. Contact
Shadowcat Systems Ltd.  mst (at) shadowcatsystems.co.uk for more information

+ Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +