RE: Script to test connecting to Oracle DBs

2012-08-01 Thread Martin Gainty
. Date: Sat, 28 Jul 2012 13:45:18 +1200 Subject: Script to test connecting to Oracle DBs From: newbie01.p...@gmail.com To: beginners@perl.org; dbi-us...@perl.org Hi all, I am looking for a Perl script or something similar that I can use to test connection from a client PC to several databases

Re: Script to test connecting to Oracle DBs

2012-08-01 Thread Leo Susanto
use strict; use DBI; use DBD::Oracle qw(:ora_types); my $user = ''; my $passwd = ''; my $tnsName = ''; $ENV{'ORACLE_HOME'} = 'C:\oracle\product\10.2.0\client_1'; my $dbh = DBI-connect(dbi:Oracle:$tnsName, $user, $passwd); my $SQL = qq{ SELECT XXX}; my $sth0 = $dbh-prepare($SQL); print SQL is

Script to test connecting to Oracle DBs

2012-07-27 Thread newbie01 perl
Hi all, I am looking for a Perl script or something similar that I can use to test connection from a client PC to several databases on a server. Does anyone know of any such script lying around somewhere :(- Currently, am testing connection from a client PC to an Oracle DB using Oracle's

Re: Script to test connecting to Oracle DBs

2012-07-27 Thread Rob Dixon
On 28/07/2012 02:45, newbie01 perl wrote: Hi all, I am looking for a Perl script or something similar that I can use to test connection from a client PC to several databases on a server. Does anyone know of any such script lying around somewhere :(- Currently, am testing connection from