It used to be called Oracle::Procedures, but since only the current implementation is Oracle-dependent and the interface is not (I think, but I really know only Oracle) I changed the name.
I like DBIx::Procedures, with DBIx::Procedures::Oracle for your current incarnation.
Too late...
a) It has entered CPAN as DBIx::ProcedureCall
http://search.cpan.org/~thilo/DBIx-ProcedureCall-0.03/ProcedureCall.pm
b) DBIx::Procedures::Oracle is very close to the already existing DBIx::Procedure::Oracle
Note that while it only supports Oracle now, there could be drivers for other databases.
The interface stays the same, the module would automatically load the correct driver according to what kind of DBI handle you throw at it.
The word "Oracle" does not appear in code that uses the module (except in the DBI connect string):
use DBIx::Procedures qw ( funny_function );
my $dbh = DBI->connect("....");
my $a = funny_function ( $dbh );Above code would look the same for Oracle and for PostgreSQL.
(Of course, at the moment, funny_function would fail with anything except an Oracle connection, because it could not load the appropriate driver).
If someone writes drivers for other databases, I would like to bundle them.
This should not be a problem because the drivers are small, pure Perl and can install without any dependencies ( they only need DBI and DBD at run-time).
Thilo
