Re: Embedding perl in Oracle

Geez Andy, where *do* you get the energy. :)

Jared

On Wednesday 05 December 2001 02:22, 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.rea
> >dme 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: Jared Still
  INET: jkstill_at_cybcon.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).