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
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
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
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
[EMAIL PROTECTED] ("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
whic
On 8/22/07, Octavian Rasnita <[EMAIL PROTECTED]> 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 wor
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
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http:
:32 AM
To: beginners@perl.org
Subject: Perl connecting to Oracle and SQL Server databases ...
Hi all,
Does anyone know of any resource that I can go to for example on
connecting to Oracle and Microsoft SQL Server databases using Perl
??? I need more than connecting to the database, some e
ginners@perl.org
>Subject: Perl connecting to Oracle and SQL Server databases ...
>
>Hi all,
>
>Does anyone know of any resource that I can go to for example on
>connecting to Oracle and Microsoft SQL Server databases using Perl
>??? I need more than connecting to the databa
Hi all,
Does anyone know of any resource that I can go to for example on
connecting to Oracle and Microsoft SQL Server databases using Perl
??? I need more than connecting to the database, some example on how
to do SELECT, INSERT, UPDATE and DELETE will be very helpful as well.
Thanks
On Aug 23, 2006, at 7:52 AM, anand kumar wrote:
Can anyone please explain how to connect to oracle database
server using perl script which is in separate linux server. Please
note that currently I am using putty to connect to linux server for
perl scripting and we have the Oracle database
Hi all
Can anyone please explain how to connect to oracle database server using perl
script which is in separate linux server. Please note that currently I am using
putty to connect to linux server for perl scripting and we have the Oracle
database on a windows server. I have tried using t
Hello. I am using Windows 2000 to connect to an Oracle database over the company
network. I have the DBI/DBD drivers installed on my computer. I want to connect using
the script below. When i run the script, it doesn't come back with anything. It just
goes to the command prompt. Can someone tell
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Charles Belcher) writes:
>is there an alternative to using DBI and DBD::Oracle to connect to an Oracle
>database to run a simple select statement?
You could run sqlplus from Perl like any other program.
I would find it simpler to use DBI and DB
is there an alternative to using DBI and DBD::Oracle to connect to an Oracle
database to run a simple select statement?
**
Mercantile Bankshares Corporation Confidential Electronic Mail:
The information contained in this message
15 matches
Mail list logo
