Tim:
I corrected the problem in the script of the following form:
my $dbh = DBI->connect('dbi:Oracle:',
shift||'',
shift||'',
'', #I changed 'Oracle' for ''
{
RaiseError => 1,
# AutoCommit => 0,
ora_session_mode => ORA_SYSDBA
})
or die DBI->errstr;
Sorry, for my english.
Thank You.
Juan
-----Original Message-----
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Monday, August 25, 2003 4:31 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: (Fwd) DBI->connect using 'old-style' syntax
----- Forwarded message from Juan Arturo Veliz Carmona
<[EMAIL PROTECTED]> -----
Delivered-To: [EMAIL PROTECTED]
From: Juan Arturo Veliz Carmona <[EMAIL PROTECTED]>
To: Tim Bunce <[EMAIL PROTECTED]>
Subject: DBI->connect using 'old-style' syntax
Date: Mon, 25 Aug 2003 12:42:02 -0400
Return-Receipt-To: Juan Arturo Veliz Carmona <[EMAIL PROTECTED]>
Hi ...
I installed DBD::Oracle 1.14 and DBI 1.37, but
I receive the following warning in test.pl:
> perl prueba.pl <user> <password>
DBI->connect using 'old-style' syntax is deprecated and will be an error in
future versions at prueba.pl line 6
scel
SYS
Is this a bug ??
Thank You
Juan
------------------------ test.pl
------------------------------------------------------------
#!perl
use strict;
use DBI;
use DBD::Oracle qw(:ora_session_modes);
my $dbh = DBI->connect('dbi:Oracle:',
shift||'',
shift||'',
'Oracle',
{
RaiseError => 1,
# AutoCommit => 0,
ora_session_mode => ORA_SYSDBA
})
or die DBI->errstr;
print $dbh->selectrow_array('select instance_name from v$instance') . "\n";
print $dbh->selectrow_array('select user from dual') . "\n";
$dbh->disconnect;
__END__
----------------------------------------------------------------------------
----------------------
-----Original Message-----
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 6:59 PM
To: Juan Arturo Veliz Carmona
Cc: Tim Bunce
Subject: Re: "ora_session_modes" is not defined in
%DBD::Oracle::EXPORT_TA GS
On Thu, Aug 21, 2003 at 06:05:00PM -0400, Juan Arturo Veliz Carmona wrote:
> Tim:
>
> My version of DBD::Oracle is :
>
> jvelizca.startel3> perldoc perllocal
>
> User Contributed Perl Documentation PERLLOCAL(1)
>
> Mon Mar 10 10:31:03 2003: "Module" DBI
> o "VERSION: 1.14"
>
> Mon Mar 10 11:15:56 2003: "Module" DBD::Oracle
> o "VERSION: 1.06"
Both very old. See search.cpan.org
Tim.
"La informaci�n contenida en esta transmisi�n es confidencial, amparada por
secreto profesional y est� dirigida exclusivamente a �l o los destinatarios
indicados. Cualquier uso, reproducci�n, divulgaci�n o distribuci�n por otras
personas que su(s) destinatario(s) est� estrictamente prohibida. Si ha
recibido este correo por error, por favor, notif�quelo inmediatamente al
remitente por e-mail o telef�nicamente por cobro revertido al (56-2) 6616000
y b�rrelo de su sistema. Las opiniones expresadas en este correo son las de
su autor y no son necesariamente compartidas o apoyadas por la compa��a.
Telef�nica M�vil no asume obligaciones ni se responsabiliza del contenido de
este correo, a menos que dicha informaci�n sea confirmada por escrito por un
representante autorizado. No se garantiza que la transmisi�n de este correo
sea segura o libre de errores, podr�a haber sido viciada, perdida,
destruida, haber llegado tarde, de forma incompleta o contener virus.
The information contained in this transmission is confidential, subject to
professional secret and is intended only for the individual named. Any
review, dissemination, distribution or copying of this transmittal is
strictly prohibited. If you have received this e-mail in error, please
immediately notify the sender by return e-mail or by calling collect to
number (56-2) 6616000 and delete it from your system. The views expressed in
this e-mail are solely those of the author and may not necessarily be those
of, or supported by, the company. Telefonica M�vil neither assumes
obligations nor accepts liability for the content of this e-mail, unless
that information is subsequently confirmed in writing by a duly authorised
representative. E-mail transmission cannot be guaranteed to be secure or
error-free as information could be corrupted, lost, destroyed, arrive late
or incomplete, or contain viruses."
----- End forwarded message -----
"La informaci�n contenida en esta transmisi�n es confidencial, amparada por
secreto profesional y est� dirigida exclusivamente a �l o los destinatarios
indicados. Cualquier uso, reproducci�n, divulgaci�n o distribuci�n por otras
personas que su(s) destinatario(s) est� estrictamente prohibida. Si ha
recibido este correo por error, por favor, notif�quelo inmediatamente al
remitente por e-mail o telef�nicamente por cobro revertido al (56-2) 6616000
y b�rrelo de su sistema. Las opiniones expresadas en este correo son las de
su autor y no son necesariamente compartidas o apoyadas por la compa��a.
Telef�nica M�vil no asume obligaciones ni se responsabiliza del contenido de
este correo, a menos que dicha informaci�n sea confirmada por escrito por un
representante autorizado. No se garantiza que la transmisi�n de este correo
sea segura o libre de errores, podr�a haber sido viciada, perdida,
destruida, haber llegado tarde, de forma incompleta o contener virus.
The information contained in this transmission is confidential, subject to
professional secret and is intended only for the individual named. Any
review, dissemination, distribution or copying of this transmittal is
strictly prohibited. If you have received this e-mail in error, please
immediately notify the sender by return e-mail or by calling collect to
number (56-2) 6616000 and delete it from your system. The views expressed in
this e-mail are solely those of the author and may not necessarily be those
of, or supported by, the company. Telefonica M�vil neither assumes
obligations nor accepts liability for the content of this e-mail, unless
that information is subsequently confirmed in writing by a duly authorised
representative. E-mail transmission cannot be guaranteed to be secure or
error-free as information could be corrupted, lost, destroyed, arrive late
or incomplete, or contain viruses."
