On Fri, Aug 03, 2007 at 08:17:12PM +0200, Marc Lambrichs | Mélange IT wrote:
> How should I handle executing a pl/sql-block in dbic? Actually I
> think there should be 2 answers to this question:
>
> 1. If you just want to execute an arbitrary block of pl/sql, you
> should be able to call it from an DBIx::Class::Schema instance.
$schema->storage->dbh->do('func()');
> 2. If you wanted to call a stored procedure, say a function that
> returns an id of a table 'account' for instance, you would like to
> add a wrapper subroutine that automagically inflates the id to the
> appropriate object. I'm not sure if this should be part of the schema.
http://search.cpan.org/~mstrout/DBIx-Class-0.08003/lib/DBIx/Class/Manual/Cookbook.pod#Arbitrary_SQL_through_a_custom_ResultSource
--
Matt S Trout Need help with your Catalyst or DBIx::Class project?
Technical Director Want a managed development or deployment platform?
Shadowcat Systems Ltd. Contact mst (at) shadowcatsystems.co.uk for a quote
http://chainsawblues.vox.com/ http://www.shadowcat.co.uk/
_______________________________________________
List: http://lists.rawmode.org/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]
