All the Perl that's Practical to Extract and Report

extproc_perl - sweet!

djberg96 on 2003-07-12T15:06:19

Someone over on #perl pointed me to this talk which I hadn't heard of before called "extproc_perl: Embedding Perl in Oracle", by Jeff Horwitz.

This is pretty damn awesome. Imagine being able to search an Oracle database using Perl regular expressions. Or using a Perl subroutine as an Oracle stored procedure or trigger. Sweet!

PostgreSQL has had this for quite a while

merlyn on 2003-07-12T15:54:32

And yeah, it does make some things particularly interesting.

Re:PostgreSQL has had this for quite a while

jhorwitz on 2003-07-14T17:50:25

Like making certain talks run over into yours. ;-)

Another solution

rob_au on 2003-07-12T23:59:56

I was particularly excited about this too when I came across it a while back - I also found the documentation in Perl for Oracle DBAs (also available on Safari) relating to extproc to be particularly useful.

Another option available too for embedding Perl into the database back-end is PostgreSQL in the form of PL/Perl (or PL/PerlU if installed in the untrusted form) - The current limitations of this implementation of Perl though is that PL/Perl functions cannot call each other directly and that these functions cannot be used as triger functions.