For Programmers: Free Programming Magazines  


Home > Archive > PERL Beginners > August 2007 > connecting to Oracle









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author connecting to Oracle
Octavian Rasnita

2007-08-22, 7:59 am

Hi,

I want to make a program that connects to a remote Oracle database and then
make it a .exe Windows executable.

Is it possible to make it not depend on Oracle's client?

Thanks.

Octavian

Chas Owens

2007-08-22, 6:59 pm

On 8/22/07, Octavian Rasnita <orasnita@gmail.com> wrote:
> Hi,
>
> I want to make a program that connects to a remote Oracle database and then
> make it a .exe Windows executable.
>
> Is it possible to make it not depend on Oracle's client?
>
> Thanks.
>
> Octavian


Yes, but it would be a lot of work, slow, buggy, and a complete waste
of your time. It is better to either distribute the Oracle client
libraries or require that your users have them. As for packaging up
all of your code into one file see PAR* and PAR::Packer**. You should
be able to include the Oracle client libraries inside the file
PAR::Packer creates. You should also look at the DBI*** and
DBD::Oracle**** if you haven't already.

* http://par.perl.org/wiki/Main_Page
** http://search.cpan.org/~smueller/PA...b/PAR/Packer.pm
*** http://search.cpan.org/~timb/DBI-1.58/DBI.pm
**** http://search.cpan.org/~pythian/DBD...-1.19/Oracle.pm
Rahed

2007-08-24, 7:01 pm

orasnita@gmail.com ("Octavian Rasnita") writes:

> Hi,
>
> I want to make a program that connects to a remote Oracle database and
> then make it a .exe Windows executable.
>
> Is it possible to make it not depend on Oracle's client?


Install Oracle Instant Client, build DBD::Oracle and then try
which libraries are necessary to include in your exe program via pp
(Perl Packager).

--
Radek
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com