Hello,
I have in mysql table kl: ID, value, flow
now, when I run in mysql:
UPDATE kl SET value = 10, flow = value - 10 where ID = 5;
it works. But when I write that in script:
my $sth = $dbh-prepare_cached(UPDATE kl SET value = ?, flow = value - ? WHERE
ID = ?);
$sth-execute( 10, 10, 5 );
I
Hello,
I am getting this error while trying to connect to an Oracle server
from a custom perl module:
DBI connect('','x',...) failed: ERROR OCIEnvNlsCreate (check
ORACLE_HOME and NLS settings etc.)
I get this error _only_ if I use my module from mod_perl2, otherwise
it works fine (a command
What are the values of your Oracle environment (ORACLE_HOME, ORACLE_SID, NLS*)?
How are they set? Are they correct (refer to correct directories, etc.)? ARe
you sure you are using the correct perl?
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From:
Hi Ron:
ORACLE_HOME: /u01/app/oracle/OraHome_1
TWO_TASK: servicename
NLS_LANG: AMERICAN_AMERICA.UTF8
As I said, this works from the command line, (if I don't go through
mod_perl), the paths are fine, I have only one perl installed
On Mon, 7 Feb 2005 11:49:16 -0700, Reidy, Ron
[EMAIL PROTECTED]
Hi,
Does the webuser have these configure (apache.conf with env?)? If
not then the web account(nobody) may not have these env setup.
Michael
Date: Mon, 7 Feb 2005 10:55:12 -0800
From: Juan Jose Natera [EMAIL PROTECTED]
To: Reidy, Ron [EMAIL PROTECTED]
Cc: DBI Users