ANN: PostgreSQL support in DBIx::ProcedureCall
From: Thilo Planz (thilo.planz_at_gaiax.co.jp)
Date: 02/14/05
- Previous message: Tim Bunce: "Re: problem in fetching clob data in db2"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
To: dbi-users@perl.org Date: Mon, 14 Feb 2005 20:31:38 +0900
Hi all,
the new version (0.07) of DBIx::ProcedureCall has support for
PostgreSQL (in addition to Oracle) now.
So if you have functions like these:
1) CREATE FUNCTION some_select() RETURNS SETOF pg_user AS $$
SELECT * FROM pg_user;
$$ LANGUAGE SQL;
2) the built-in power(number, number)
You can call them from Perl like so:
use DBIx::ProcedureCall qw(
some_select:fetch[[]]
power
);
my $conn = DBI->conn(.....);
# 1)
my $array_or_arrays = some_select($conn);
# 2)
my $power = power($conn, 5, 3); # should be 125
Oracle users, too, might be interested in some of the more recent
features:
- table functions
- functions that return cursors
- OUT and INOUT parameters
Now on CPAN, feedback and questions appreciated:
http://search.cpan.org/dist/DBIx-ProcedureCall/
Cheers,
Thilo
- Previous message: Tim Bunce: "Re: problem in fetching clob data in db2"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
