Grokbase
Topics Posts Groups | in
x
[ help ]

[Dbix-class] executing pl/sql block in dbic

View PostFlat  Thread  Threaded
Marc Lambrichs | Mélange IT [Dbix-class] executing pl/sql block in dbic
| +1 vote
[ Profile | Reply to group ] [ Flat  Thread  Threaded ]
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.
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.

Cheers,

Marc Lambrichs
==================================
Mélange IT B.V.
http://www.melange-it.com
==================================

Thread : [Dbix-class] executing pl/sql block in dbic
1)
Marc Lambrichs | Mélange IT How should I handle executing a pl/sql-block in dbic? Actually I think there should be 2 answers to...
spacer
View PostFlat  Thread  Threaded