On Dec 28, 2007, at 9:42 AM, Jason Kohles wrote:
On Dec 28, 2007, at 3:59 AM, Tony Winslow wrote:
Hi, all!
I've stored procedures defined in my database schema, and I need to
call them in my code.
The arbitrary-sql approach won't help since it writes sql
statements in source code to act as stored procedures. So could I
do that in DBIx?
From DBIx::Class::Manual::Cookbook:
Also from DBIx::Class::Manual::Cookbook:
Using database functions or stored procedures
The combination of "select" and "as" can be used to return the
result
of a database function or stored procedure as a column value.
You use
"select" to specify the source for your column value (e.g. a
column
name, function, or stored procedure name).
--
Jason Kohles, RHCA RHCDS RHCE
[EMAIL PROTECTED] - http://www.jasonkohles.com/
"A witty saying proves nothing." -- Voltaire
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]
