I'm fully aware that DBI allows one to execute Oracle PL/SQL stored procedures via a simple prepare(..) statement (as in the example below..):

# ...
my $dbh = DBI->connect('dbi:Oracle:host', 'user', 'pass')
    || die $DBI::errstr;

eval {
    my $db_proc = $dbh->prepare(qq|
                   BEGIN
                        my_procedure(:foo);
                   END;
                  |);

    $db_proc->bind_param(':foo', 'bar');
    $db_proc->execute;
    $db_proc->finish;

    $dbh->commit;
};
if ($@) {
    $dbh->rollback;
}

# ...
[download]

However, exactly same code that I'd used to execute PL/SQL stored procedures wouldn't work for Java stored procedures.

Would any monk out there have any idea how I could make this work?

Your help is much appreciated ;-)

"There is no system but GNU, and Linux is one of its kernels." -- Confession of Faith