Grokbase
Topics Posts Groups | in
x
[ help ]

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

View TopicPrint | Flat  Thread  Threaded
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...
| +1 vote (Anchor)
[ 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
==================================
spacer
View TopicPrint | Flat  Thread  Threaded
Home > Groups > DBIx::Class > [Dbix-class] executing pl/sql block in dbic (1 post)