Tim,
Will you be posting the this talk any time soon?
On 27-Dec-01 Tim Bunce wrote:
> 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.readm
>> > e
>> > 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
----------------------------------
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 08-Feb-02
Time: 09:20:40
----------------------------------
