I recently came across a very interesting talk at OSCON that I hadn’t
heard about before called “extproc_perl: Embedding Perl in Oracle”, by
Jeff Horwitz. extproc_perl embeds a Perl interpreter in an external
Oracle procedure, allowing you to search Oracle tables using Perl
regular expressions, or even use Perl code as a stored procedure.
You can find the synopsis and PowerPoint download here:
http://conferences.oreillynet.com/cs/os2003/view/e_sess/3731
The module itself is available on CPAN.
In light of recent development on ruby9i, I think this is something
worth keeping in mind. I know I would love to see something like this
for Ruby.
Regards,
Dan
PS - Some of the slides will not work properly with OpenOffice or
StarOffice in slideshow mode.