Re: Embedding perl in Oracle

Tim,

That sounds rather interesting, as the impression that MySQL users sometimes give is that they're perfectly happy with MySQL and don't have any need to move to Oracle or anything else.

Any particular features of Oracle that the owners feel they need, or is it a move to satisfy investors/auditors/etc.?

Jared

                                                                                       
                             
                    Tim Bunce                                                          
                             
                    <Tim.Bunce_at_pob       To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>        
                    ox.com>              cc:                                           
                             
                    Sent by:             Subject:     Re: Embedding perl in Oracle     
                             
                    root_at_fatcity.c                                                     
                             
                    om                                                                 
                             
                                                                                       
                             
                                                                                       
                             
                    12/05/01 03:30                                                     
                             
                    AM                                                                 
                             
                    Please respond                                                     
                             
                    to ORACLE-L                                                        
                             
                                                                                       
                             
                                                                                       
                             

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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jared.Still_at_radisys.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).