Thanks for the info John. Agreed that it is probably an issue with the
connect string. More details on the environment
The oracle RAC environment is 64bit 11gR2 running on windows server
2003.
The client is currently a 32 bit 10.2 oracle client running on a
different 64 bit windows
Found the issue.
Had been connecting as
my $dbh = DBI-connect(dbi:Oracle:host=edc-dbserver;sid=HCSMDA,
ais_dbo, PASSWORD,...
and getting the error. Changed it to
my $dbh = DBI-connect('dbi:Oracle:',
'ais_...@edc-dbserver/HCSMDA','PASSWORD',...
and all is well.
Thanks for the help.
Rebuilding DBD::Informix on the new system resolved my problems.
Thanks again to all that provided assistance!
Royce
From: Jonathan Leffler jonathan.leff...@gmail.com
To: Royce Miller royce...@pacbell.net
Cc: dbi-users@perl.org; Guardian of DBD::Informix
I am using DBI to connect to a DB2 LUW database. It seems I cannot use DBI to
issue the IMPORT command.
my $dbh = DBI-connect( dbi:MSDB2:$DB_NAME, '', '', { 'RaiseError' = 1 } );
dbh-do(import from $filename of del insert into $tabname);
DBD::MSDB2::db do failed: [IBM][CLI
Hi All,
I am executing list of SQL queries from a file. Currently if there is any
error (like syntax issue) in any of the sql query it doesn't processes the
other remainig queries.
I tried executing the queries in 'eval' but it doesn't seem to work. I am
using DBI and DBD::Oracle
Cheers,
Parag
- Original Message
From: Parag Kalra paragka...@gmail.com
I am executing list of SQL queries from a file. Currently if
there is an error (like syntax issue) in any of the sql query it doesn't
processes the other remainig queries.
I tried executing the queries in 'eval' but it
I am executing simple insert SQL queries in a loop
I have a simple requirement - While insert quieries are being executed, if
any error occurs it should print that message and move to next insert sql
query. I am using DBD::Oracle on Unix
Cheers,
Parag
On Fri, Apr 30, 2010 at 1:10 PM, Ovid
- Original Message
From: Song, Melinda qing.s...@morganstanley.com
I am using DBI to connect to a DB2 LUW database. It seems I cannot use DBI to
issue the IMPORT command.
my $dbh = DBI-connect(
dbi:MSDB2:$DB_NAME, '', '', { 'RaiseError' = 1 } );
dbh-do(import
from $filename
On Apr 30, 2010, at 1:26 PM, Parag Kalra wrote:
I am executing simple insert SQL queries in a loop
I have a simple requirement - While insert quieries are being
executed, if
any error occurs it should print that message and move to next
insert sql
query. I am using DBD::Oracle on Unix
On Fri, Apr 30, 2010 at 4:36 PM, Ovid publiustemp-d...@yahoo.com wrote:
- Original Message
From: Song, Melinda qing.s...@morganstanley.com
I am using DBI to connect to a DB2 LUW database. It seems I cannot use DBI to
issue the IMPORT command.
my $dbh = DBI-connect(
We have a lot of similar queries (see attached) that return a non-unique
identifier and two varrays. One varray is a timestamp array and the other is a
float value array. See attached SQL. We are currently returning on the order
of 1600 rows. We would like to change the settings in
First I would upgrade to 1.24 that would speed things up conciderably as it can
do more than on fow per round trip fetch.
The problem with VARRAY is that you have to iterate over the arrary at each
select to build up the perl array. While it is done in OCI (C) it will still
take time.
This is a case of RTFM
http://search.cpan.org/~timb/DBI-1.611/DBI.pm#PrintError_(boolean,_inherited)
PrintError will just print the error and go on its merry way
From: paragka...@gmail.com
Date: Fri, 30 Apr 2010 12:39:38 -0700
Subject: How to discard the error in SQL query
To:
13 matches
Mail list logo