DBIx::ProcedureCallDBIx::ProcedureCall is a Perl extension to make database stored procedures look like Perl subroutines. | |
Download |
DBIx::ProcedureCall Ranking & Summary
Advertisement
- License:
- Perl Artistic License
- Price:
- FREE
- Publisher Name:
- Thilo Planz
- Publisher web site:
- http://search.cpan.org/~thilo/DBIx-ProcedureCall-0.10/ProcedureCall.pm
DBIx::ProcedureCall Tags
DBIx::ProcedureCall Description
DBIx::ProcedureCall is a Perl extension to make database stored procedures look like Perl subroutines. SYNOPSIS use DBIx::ProcedureCall qw(sysdate); my $conn = DBI->connect(.....); print sysdate($conn);When developing applications for a database that supports stored procedures, it is a good idea to put all your database access code right into the database..This module provides a convenient way to call stored procedures from Perl by creating wrapper subroutines that produce the necessary SQL statements, bind parameters and run the query.While this module's interface is database-independent, only Oracle and PostgreSQL are currently supported.EXPORTDBIx::ProcedureCall exports subroutines for any stored procedures (and functions) that you ask it to. You specify the list of procedures that you want when using the module: use DBIx::ProcedureCall qw # gives you print sysdate($conn);Calling such a subroutine will invoke the stored procedure. The subroutines expect a DBI database handle as their first parameter. Requirements: · Perl
DBIx::ProcedureCall Related Software