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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
