On Thu, Nov 25, 2004 at 04:23:05PM +0900, Thilo Planz wrote: > Hi all, > > I have been using Oracle PL/SQL fairly extensively these days, and came > up with a module that creates Perl wrappers for PL/SQL procedures, so > that I can call them just like Perl functions (without the need to > write SQL statements or to manually bind parameters). > > After some discussion with the Perl monks, I decided that DBIx::Call > would be a good name for putting the module on CPAN. > (Although only Oracle is implemented now, it could be made to work with > other databases). > > Any objections to what it does, how it does it, or the name?
DBIx::Call is a little too short. DBIx::ProcedureCall may be a mouthful and doesn't mention functions, but it is very clear, and better for it. > Do you think it is at all useful? Sure. I've wanted to add something along these lines to the DBI. But I've not had time to compare the various modules and try to distill the best of each. This is a useful addition to the mix. I'd be interested to know what users of other databases think of the API. Specifically if the API would be too limited for their database. One quick suggestion... currently the performance is limited by using prepare(). You could allow the importer to specify if they'd like to use prepare_cached for extra speed: use DBIx::ProcedureCall qw(sysdate:cached dbms_random.initialize); so sysdate($dbh) then uses prepare_cached(). Tim. > Module: http://perl-pad.sourceforge.net/dbi/DBIx-Call-0.02.tar.gz > Perldoc : http://perl-pad.sourceforge.net/dbi/Call.html > Thread on Perlmonks: http://perlmonks.org/index.pl?node_id=410058 > > Cheers, > > Thilo > > > > >
