-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> when a constraint was violated by an INSERT statement, I would like to
> find out which constraint that was (i.e. it's name).
> .
> What's the recommended way to do that?
The database will return the error to you. Just peek at $DBI::errstr
afte
Robert,
Look ate your INSERT statement and the ordering of your bind variables.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Reidy, Ron
Sent: Thursday, September 30, 2004 12:43 PM
To: Robert; DBI-Users
Subject: RE: DBD-Oracle
Is the binding happ
Is the binding happeneing in the same manner?
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Robert [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 30, 2004 12:21 PM
To: Reidy, Ron; DBI-Users
Subject: RE: DBD-Oracle
Changing the order did n
Changing the order did not help, I am still getting same error.
"Reidy, Ron" <[EMAIL PROTECTED]> wrote:I'm no expert on DBD::CSV, but it looks like
the ordering of your columns in your select list is not mapping correctly to the
format of your input file. The key to this is located in the DBI tr
I'm no expert on DBD::CSV, but it looks like the ordering of your columns in your
select list is not mapping correctly to the format of your input file. The key to
this is located in the DBI trace log. Look for "[Ron Reidy]" below:
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-
Hi list, I am trying to load the following data into Oracle table which has a date
column
bash-2.03$ cat processed.csv
test.com|16/Aug/2004:15:06:14|/index.html|demo1|Demo Company|
test.com|16/Aug/2004:15:06:15|/index.jhtml|demo1|Demo Company|
test.com|16/Aug/2004:15:06:54|/index.jhtml|demo1|
Thanks Ron, for pointing me to right link.
It's resolved now. I was hitting 4000 bytes limit, eventhough
the string length is around 1390 characters due to my NLS_LANG
setting(WE8..) and Oracle8's interpretation of anything > 4000 as LONG.
Now i'm truncating the string to 1300 characters and it wor
## Cc: [EMAIL PROTECTED]
On "make test", I get the following. Since the Oracle.dll is definitely where
the install driver is located, I assume that the Oracle.dll can't hook up
with the dll in $ORACLE_HOME. I have that as "C:\\sys\\ora8p" and also tried
it as "/cygdrive/c/sys/ora8p" - and in bot
> From: Tim Bunce <[EMAIL PROTECTED]>
> Date: 2004/09/30 Thu PM 03:06:59 GMT
> I think you'll find execute_for_fetch() much easier to work with.
So, I've followed your recommendation, but I'm having just a bit of an issue...
if ($insCount == $sendRows) {
my $temp_count = 0;
my @tuple_status;
Hello:
Since posting this problem, there has been 4-5 good responses except each
respondent has their own way of doing things. I am doing a fresh install of
RH9 & mysql-4.0.21. After that I will install PERL. Since I am in the
learning process, I do need the actual instructions. From what I can fi
> From: Tim Bunce <[EMAIL PROTECTED]>
> Date: 2004/09/30 Thu PM 03:06:59 GMT
>
> I think you'll find execute_for_fetch() much easier to work with.
Hmm... Okay, checking it out...
> Also, I've changed bind_param_array() for the next release so it
> doesn't require all bind arrays to have the sam
I think you'll find execute_for_fetch() much easier to work with.
Also, I've changed bind_param_array() for the next release so it
doesn't require all bind arrays to have the same number of elements.
Meanwhile you'll need to pad out the smaller ones with undefs.
Tim.
On Thu, Sep 30, 2004 at 02:3
Hello all,
I'm still having just a bit of trouble with execute_array. I want to parse my input
file, break it apart with Text::CSV_XS (thanks for the great recommendation!), then
build arrays corresponding to each column. Everything works great, it really does.
But, I don't want to parse
Thanks to Jeff Urlwin there are now PPDs for DBD::Sybase available from
http://ftp.esoftmatic.com/DBI/. The build is for ActivePerl 5.8.4, and
was built with Sybase's 12.5.1 client libraries. If you don't have the
12.5.1 libs you can get them with the 12.5.2 developer edition of ASE
from Sybase's w
On Thu, 2004-09-30 at 00:01, Henri Asseily wrote:
> By default the first thing we do here on a redhat 9 install is as root:
> mv /etc/sysconfig/i18n /etc/sysconfig/i18n.orig
>
> upon reboot, you should be good.
> If you don't want to reboot, just do "unset LANG" before running the
> Makefile (or
15 matches
Mail list logo