Got the Pause message, thanks Tim.
STH
On 08-Feb-02 Scott T. Hildreth wrote:
>
> 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.read
>>> > m
>>> > 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
> ----------------------------------
----------------------------------
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 08-Feb-02
Time: 11:01:42
----------------------------------
