DBIx::ProcedureCall

DBIx::ProcedureCall is a Perl extension to make database stored procedures look like Perl subroutines.
Download

DBIx::ProcedureCall Ranking & Summary

Advertisement

  • Rating:
  • 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