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
