On 17/02/2011 4:38 PM, Bobak, Mark wrote:
Sorry Mark I saw that
PI_CIBD_CODE_TAB was a clob so that is where I though you where having your
problem. There is such a thing
as a nvarchar never used it myself perhaps that will help.
Sorry, but I'm not sure I understand the suggestion. NCLOB
I had this problem quite awhile ago with an old Oracle 9.2 database.
I don't remember why but the solution involved setting a couple of environment
vars.
Looking back at those ancient, no longer used, problems I see
$ENV{NLS_LANG} = american_america.we8iso8859p1;
$ENV{ORA_NLS} =
Thanks for the suggestion, Erick.
In my case, I already had NLS_LANG set to AMERICAN_AMERICA.AL32UTF8 (which is
my db character set).
I didn't have anything set for ORA_NLS, but I tried setting it to
$ORACLE_HOME/nls/data (which is my guess as to the 11.2 equivalent of the
directory you had
Tired the NVARCHAR2, it had no effect.
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent: Friday, February 18, 2011 7:03 AM
To: Bobak, Mark
Cc: dbi-users@perl.org
Subject: Re: Problem with UTF8 and array binding
On 17/02/2011 4:38 PM, Bobak, Mark wrote:
Sorry
Then, I guess, the text was not utf8, you set the flag, but did you actually
convert the text to a UTF-8 format, perhaps an explicit encode('utf8',
$text) call?
Just a thought.
Also some more food for thought about utf8 and UTF-8
Hello,
It's been a looong time since I've been able to post tot his list. I miss Perl
more then my ex-wife. Anyway. There was a time when I had built this great Perl
app using DBI. I remember looping through the dB and inside a while loop
assigning the values from the cells to keys (scalars)
I'm getting the following error: (some data has been change to protect the
bystanders.)
DBD::Oracle::st execute failed: called with 18 bind variables when 19 are
needed [for Statement insert into edsbase
You're probably calling do($sql, @args) when you should call do($sql, undef,
@args)
On Fri, Feb 18, 2011 at 11:31 AM, Bruce Johnson
john...@pharmacy.arizona.edu wrote:
I'm getting the following error: (some data has been change to protect the
bystanders.)
DBD::Oracle::st execute failed:
No, this is done as:
$csr=$dbh-prepare($sql)
then as $csr-execute(@parms) inside of a loop.
On Feb 18, 2011, at 12:33 PM, Bill Ward wrote:
You're probably calling do($sql, @args) when you should call do($sql, undef,
@args)
On Fri, Feb 18, 2011 at 11:31 AM, Bruce Johnson
Are you calling $csr-finish at the end of each iteration? Might not be the
issue but indeed good practice.
Carl Furst
o/~ What a difference a byte makes... o/~
-Original Message-
From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu]
Sent: Friday, February 18, 2011 3:07 PM
Cc: DBI
OK, scratch my last this indeed has changed...
http://search.cpan.org/~timb/DBI-1.616/DBI.pm#finish
Carl Furst
o/~ What a difference a byte makes... o/~
-Original Message-
From: Bruce Johnson [mailto:john...@pharmacy.arizona.edu]
Sent: Friday, February 18, 2011 3:07 PM
Cc: DBI Users
This is a quickie version of what I'm doing:
$sql =insert into foo (bar, baz, buz) values(?,?,?);
$csr = $dbh-prepare($sql);
while (ldap query runs){
@parms =($val1,$val2,$val3);
if ($val1 eq 'A'){ $csr-execute(@parms);}
}
The thing is, this is the second query to the
Tried it that way, same error.
On Feb 18, 2011, at 12:33 PM, Bill Ward wrote:
You're probably calling do($sql, @args) when you should call do($sql, undef,
@args)
On Fri, Feb 18, 2011 at 11:31 AM, Bruce Johnson
john...@pharmacy.arizona.edu wrote:
I'm getting the following error: (some
Figured it out.
The second ldap query did not return all the attributes I was looking for, and
when it returned no value for that attribute, the bind variable wasn't
populated, leading to the mismatch between expected and actual. The error is
correct.
The error MESSAGE, however contained the
14 matches
Mail list logo