[Dbix-class] [newbie]How to call stored procedure?(doc already read)

[Jason Kohles]

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 at jasonkohles.com - http://www.jasonkohles.com/
"A witty saying proves nothing."  -- Voltaire