Oracle extproc_perl

[UnderMine]

I am looking for anyone who has had any experience of using the extproc_perl module that has recently appeared on CPAN for creating Oracle external stored procedure.

I am attempting to determine whether to use this or go with the more traditional PLSQL/Java approach to writing Oracle external stored procedures.

Currently we use Perl and PL/SQL in house and I would be nice if we did not have to add another language to the system. Currently it appears that only unix has been tested.

All feedback welcome.

Hopefully
UnderMine

[Three]

Doing a pl/sql app with regular DBI works fine for me. ex.


use DBI;

my $dbh = DBI->connect('DBI:Oracle:db','uid','pwd');

$dbh->do("DECLARE\nBEGIN\nDELETE FROM TBL;\nEND;");

$dbh->disconnect;

[UnderMine]

Sorry I don't think I made myself clear enough

Using DBD::Oracle is fine when you are running a perl script that needs to talk to a Oracle and that is what we currently do.

extproc_perl allows ORACLE to call perl not the other way round. ;)

Hope that is clearer
UnderMine