Re: Embedding perl in Oracle

I'm putting together a "Using Perl with Oracle" talk (for the Perl Whirl '02 GeekCruise conference) and would very much like to hear from anyone who's used Jeff's extproc_perl.

The talk, like all my others, will be available from

        http://cpan.valueclick.com/authors/id/TIMB/ once it's done.

Thanks.

Tim.

p.s. cross-posted to oracle-l and dbi-users, please reply direct or ammend any followups.

On Wed, Dec 05, 2001 at 02:22:07AM -0800, Andy Duncan wrote:
> Hi Tim,
>
> > > I've done it, it works. Be aware that setting it up is not trivial,
> > > as the documentation is somewhat incomplete.
> > > That is being remedied however...
> > > http://www.cpan.org/modules/by-authors/Jeff_Horwitz/
> > http://www.cpan.org/modules/by-authors/Jeff_Horwitz/extproc_perl-0.93.readme
> > I'll take a look and add that to my Perl Whirl talk.
>
> You can also get hold of all of Jeff's other work, including the latest
> extproc_perl, at his personal site:
>
> => http://www.smashing.org/
>
> It's groovy, baby! :-)
>
> Also, some useful extra utiltities for using Doug MacEachern's ExtUtils::Embed,
> which is used to drive extproc_perl, along with OCIExtProcContext et al, can be
> found in the full ExtUtils::Embed tarball download. Particularly useful for
> Win32 users, is the genmake utility:
>
> => http://www.cpan.org/authors/id/DOUGM/
> => http://www.cpan.org/authors/id/DOUGM/ExtUtils-Embed-1.14.tar.gz
>
> The extproc_perl Oracle Perl Procedure Library is, IMHO, an amazing piece of
> work. Just for starters, as a super-basic example, you can write a subroutine
> in a Perl bootfile, like this:
>
> sub perl_localtime {
> my $x = localtime(time);
> return $x;
> }
>
> And get output like this:
>
> SQL> select perl('perl_localtime') localtime from dual;
>
> LOCALTIME
> ---------------------------------
> Wed Dec 5 10:12:20 2001
>
> 1 row selected.
>
> SQL>
>
> You can also link back to the Oracle database from within the Perl bootfile
> script using DBI, stay within the original transaction, and not create a new
> connection, as with SQLJ etc. Fantastic stuff!!!
>
> I really _do_ have to get out more! 8-)
>
> Rgds,
> AndyD
>
> =====
> Make Someone Happy. Buy a Copy of:
> => http://www.oreilly.com/catalog/oracleopen/
> -----BEGIN GEEK CODE BLOCK-----
> GO/SS/TW d- s+:+ a C++$ U++$ P++++$ L++$ !E W+ N+ K- W O-
> M+ V-- PS+ PE++ Y+ PGP t+@ 5 X- R* tv- b+++ DI++ D G e++
> h---- r+++ y++++
> ------END GEEK CODE BLOCK------
>
> __________________________________________________
> Do You Yahoo!?
> Buy the perfect holiday gifts at Yahoo! Shopping.
> http://shopping.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Bunce
  INET: Tim.Bunce_at_pobox.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).