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/ +
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/
