I've been tasked with exploring alternatives for developing stored procedures for an Oracle database. Googling a bit, I found some references to a project called extproc_perl that's ostensibly been under development since 2001 (last updated 2006), and I thought "Great!!". However, Google hits on the project (at least the first 100 or so) are all self-referential or CPAN. It came up on SoPW back in 2002, but that thread had no real responses. Following some CB discussion (thanks Limbic~Region, erix et al.), native support for PL/SQL, Java and .NET was raised but no Perl solutions were immediately obvious.

While any Perl solution will have an obvious performance hit, I'd like to explore all options before committing to Java (and optimizing to PL/SQL after benchmarking). Anyone here have good/bad experiences with extproc_perl to share? Anyone try tying Perl into a DB through Inline::Java::PerlInterpreter? Are there Perl-based options that I've missed?

In reply to Writing Oracle Stored Procedures in Perl by kennethk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.