RE: Perl-Oracle DBI module

2005-09-20 Thread Mitchell, Louise M
Oracle has some environment variables that are critical, such as ORACLE_HOME, NLS_LANG, etc. It appears that these are not set for the user that is doing the install. Check with your Oracle DBA if you're not familiar with these. L -Original Message- From: Trivedi, Dhirendra [mailto:[EM

Re: Perl-Oracle DBI module

2005-09-20 Thread Jonathan Leffler
So, which part of the README file did you have difficulty understanding? On 9/20/05, Trivedi, Dhirendra <[EMAIL PROTECTED]> wrote: > > Trying to install Oracle Driver for Perl I get the error message > > UNKNOWN OCI STATUS 24322) OCIInitialize. Check ORACLE_HOME > and NLS settings etc. at t/gene

Perl-Oracle DBI module

2005-09-20 Thread Trivedi, Dhirendra
Hi, Trying to install Oracle Driver for Perl I get the error message UNKNOWN OCI STATUS 24322) OCIInitialize. Check ORACLE_HOME and NLS settings etc. at t/general.t line 21 Are you able to advise a work around for this ? t/base..ok t/general...DBI->connect failed: (UNKNO

Re: DB2 Err Handling

2005-09-20 Thread Dan Scott
Tim Bunce wrote: On Fri, Sep 02, 2005 at 05:37:57PM -0500, johnn wrote: Capacio, Paula J wrote: my $stmt = 'select count(*) from sysibm.badTblnm '; my $sth = $dbh->prepare($stmt) or die "Prepare Failed\n"; DBD::DB2 doesn't seem to return false values for failures. If that's true the

Error writing to double using ODBC

2005-09-20 Thread Wim Livens
I'm having trouble writing to columns of type DOUBLE using ODBC (to Pervasive.SQL) $dbh = DBI->connect('dbi:ODBC:DEMODATA','','',{RaiseError => 1, PrintError =>1}) or die $DBI::errstr; $sth=$dbh->prepare("update mytable set mycolumn=? where id=123") || die $DBI::errstr; $value=3/2; $sth