Re: is this a viable option?

"Martin J. Evans" <[email protected]> Mon, 01 Oct 2012 19:15:11 +0100

Newsgroups	gmane.comp.lang.perl.modules.dbi.general
Organization	Easysoft Limited
Message-ID	<[email protected]>

On 01/10/2012 18:29, Jack Craig wrote:
> Hi Folks,
>
> I have an html / perl app running on host A,
>
> i want to do a remote oracle query on host B from host A.
>
> Assuming proper credentials, is this a viable configuration?
>
> This as opposed to running perl dbi module installed on host B.
>
> TIA, jackc...
>
Yes.

Install Oracle Instant Client  (you need the sdk, client, sqlplus). 
Untar it somewhere accessible from your web user.

Add untarred_dir/bin to PATH and export it.

Run sqlplus with the correct args to connect to your Oracle to prove the 
client works.

Download DBD::Oracle. Assuming Unix or Linux, set LD_LIBRARY_PATH (or 
equivalent) to point to the dir you untarred instant client into. Do the 
usual with DBD::Oracle - perl Makfile.PL, make, make test, make install.

Write Perl code using DBI module to issue query and get results.

Martin