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

RE: Script to test connecting to Oracle DBs

2012-08-01 Thread Martin Gainty
ulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > 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 lookin

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 connecti

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 sqlplus