RE: DBD-Oracle

2005-10-21 Thread David Sawyer
Yes. It's Activate State v5.8.7 for Sun multi-thread Regards, David Sawyer Senior Customer Support Engineer Ceon Corporation 650-817-6334 (office) 650-238-8078 (Blackberry Wireless) 408-832-4354 (mobile) www.Ceon.com -.- . -.. .-. ... -Original Message- From: Reidy, Ron [mailto:[

Re: Help: Oracle 10G installtion screwed up my perl

2005-10-21 Thread John D Groenveld
In message <[EMAIL PROTECTED]>, joe bayer writes: >On my WinXP sp2, I have perl 5.6.1 installed and a lot of scripts depend on th >at. Recently I installed Oracle 10g Version 2, it added a new system variable > >-- >-

Re: dbd::informix with no test db

2005-10-21 Thread Matthew Lenz
never mind, found the setting. DBD_INFORMIX_NO_ESQLTEST -Matt On Fri, 2005-10-21 at 13:37 -0500, Matthew Lenz wrote: > i have to setup a dbd::informix without being able to create a test db. > is this possible? basically everything looks like its working great > (everything is compiling fine unt

dbd::informix with no test db

2005-10-21 Thread Matthew Lenz
i have to setup a dbd::informix without being able to create a test db. is this possible? basically everything looks like its working great (everything is compiling fine until it tries to connect to a database). I can only assume there is some way around this correct? .i tried setting the mentio

Help: Oracle 10G installtion screwed up my perl

2005-10-21 Thread joe bayer
Hi, group, I used DBI a lot but not experenced in setting up perl. On my WinXP sp2, I have perl 5.6.1 installed and a lot of scripts depend on that. Recently I installed Oracle 10g Version 2, it added a new system variable ---

RE: DBD-Oracle

2005-10-21 Thread Reidy, Ron
OK. I do not believe there exists a PPM for DBD::Oracle after version 5.6.1 from AS. Supposedly, because of licensing issues. The next step would be to build DBD::Oraacle yourself. You will need the same C compiler iused to build Perl. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original

Disabling Apache::DBI

2005-10-21 Thread Ted Behling
I have multiple mod_perl applications running within one Apache instance. For most of these applications, I want to use Apache::DBI, but I want to disable it for just one. According to various Web pages, this is not possible, because Apache::DBI attaches itself to all DBI->connect() calls. I

RE: DBD-Oracle

2005-10-21 Thread Ted Behling
You appear to be using ActiveState's Perl distribution. You might have better luck installing from CPAN, as in: perl -MCPAN -e 'install DBD::Oracle' Ted Behling, ISP Systems Analyst Hargray Communications > -Original Message- > From: David Sawyer [mailto:[EMAIL PROTECTED] > Sent: Frida

RE: DBD-Oracle

2005-10-21 Thread Reidy, Ron
So, I just have to ask ... Is your Perl from AS? -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: David Sawyer [mailto:[EMAIL PROTECTED] Sent: Friday, October 21, 2005 9:01 AM To: dbi-users@perl.org Subject: DBD-Oracle I am desperately trying to install DBD-Oracle

DBD-Oracle

2005-10-21 Thread David Sawyer
I am desperately trying to install DBD-Oracle on my UNIX system. No matter what I try I get the error : [EMAIL PROTECTED] > ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.4/DBD-Oracle.ppd Error: no sui

Re: DBD::Oracle & 10.1 client

2005-10-21 Thread Tim Bunce
On Thu, Oct 20, 2005 at 03:41:01PM -0500, Scott T. Hildreth wrote: > To add more info, I was told this problem only occurs if there is only > one row returned. If more than one row is returned, the arrayref is > fine. I changed the selectall_arrayref to selectrow_array and the data > (one row re

Re: Is it a bug in DBD::SQLite? [cpan #15166]

2005-10-21 Thread Adriano Ferreira
Actually this seems an issue with SQLite 3.2. DBD::SQLite 1.09 uses 3.2.2. And it is reproducible with the Java wrapper over 3.2.1. A statement like SELECT 'a which should be a syntax error, doubles the last character, returning (in this example) a row with one column 'aa'. On 10/20/05,

Re: Odd DBI behavior

2005-10-21 Thread Tim Bunce
On Thu, Oct 20, 2005 at 04:57:24PM -0500, [EMAIL PROTECTED] wrote: > Script is below all this, and it is being performed on RHEL V3. The garbled > field is a SHA1 blob computed from the > FULLDATE,HOSTNAME,FACILITY,PRIORITY,MESSAGE fields. > > With the DBI commands commented out of this script I g

Re: DBD::Oracle & 10.1 client

2005-10-21 Thread Scott T. Hildreth
To add more info, I was told this problem only occurs if there is only one row returned. If more than one row is returned, the arrayref is fine. I changed the selectall_arrayref to selectrow_array and the data (one row returned) was fine. I'm posting to dev as well, just in case this is a kno

DBD::Oracle & 10.1 client

2005-10-21 Thread Scott T. Hildreth
I am going to investigate more, but I thought I would post the question to see if anyone has run into this problem. I have co-workers that connecting to a remote Oracle DB (10.1), I compiled DBD::Oracle 1.16 with the 10.1 client libraries. The data returned from a selectall_arrayref is 2 fields a

RE: Serializing Storable.pm objects via DBI to Oracle 10g

2005-10-21 Thread Chris Fuhrman
Not sure this would work but I can give it a shot. Reason I say this is that I tried to take the "frozen" storable object and then MIME::Base64 encode it before putting it in the data-base. Still got the same error so I'm now starting to suspect it's something going on between Storable.pm and Orac