UnderMine has asked for the wisdom of the Perl Monks concerning the following question:

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

Replies are listed 'Best First'.
Re: Oracle extproc_perl
by Three (Pilgrim) on Nov 25, 2002 at 16:57 UTC
    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;

    [download]
[reply]
[d/l]
      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

[reply]

Back to Seekers of Perl Wisdom