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

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

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

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 get

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: 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

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] mailto:[EMAIL PROTECTED] ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.4/DBD-Oracle.ppd ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.4/DBD-Oracle.ppd Error: no

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

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: Friday,

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 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.

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

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

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 until

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-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