Re: Embedding perl in Oracle

On Tue, Dec 04, 2001 at 08:26:52PM -0500, Thomas A.Lowery wrote:
> My office mate (cc'd) also set this up to demo the process. I'm
> considering testing out the possibility of using an Oracle view on
> top of function that calls a extproc_perl to a MySQL database.

I imagine that'll be at least an order of magnitude slower than using the Oracle ODBC Gateway and MyODBC to do the same thing. I'll also be read-only.

I'm due to be working on setting up a Oracle ODBC Gateway and MyODBC for a production system soonish. It's part of a strategy to simplify migration from MySQL to Oracle.

Tim.

> Tom
>
> On Wed, Dec 05, 2001 at 12:55:31AM +0000, Tim Bunce wrote:
> > On Tue, Dec 04, 2001 at 01:45:46PM -0800, Jared.Still_at_radisys.com wrote:
> > >
> > > Of course, you can already call Perl from oracle via extproc_perl.
> > >
> > > 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/
> >
> > Oh, very interesting. Thanks.
> >
> > 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.
>
> --
> Thomas A. Lowery
> See DBI/FAQ http://tlowery.hypermart.net
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.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).