recipe and Makefile.PL tweak for building DBD::Oracle on Linux with Oracle's Instant Client RPMs

2005-12-14 Thread Vonnahme, Nathan
After a day of forehead-bashing I got DBD::Oracle to compile with the Instant Client on Red Hat Enterprise Linux 4 - though I suspect it will work with most other flavors. Here are my notes for the good of the next person (and me next time I go looking): To simplify/standardize the layout of the

Help on installing DBI

2005-12-14 Thread nina . t . nguyen
Hi I am trying to install Perl 5.8.7 Build 815 and when install DBI. I am getting the following error : Unknown command 'ls'; type 'help' for a list of commands. ppm> install dbi.pm Error: No valid repositories: Error: Unexpected Content-Type 'application/x-ns-p roxy- autoconfig' returned ppm>

RE: LongReadLen, lengthb() and Oracle

2005-12-14 Thread Reidy, Ron
Ron, What data type is 'a_session'? I have never worked with this lengthb() method, but if this is truly a LONG type, there is nothing you can do with it natively in SQL (i.e. get the length). You will need tto fetch it and then get the length. Also, the dbms_lob package does not work against L

RE: LongReadLen, lengthb() and Oracle

2005-12-14 Thread Ted Behling
Found this Web page on the topic; HTH: http://www.arikaplan.com/oracle/ari80597b.html Ted Behling -Original Message- From: Ron Savage [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 13, 2005 7:39 PM To: List - DBI users Subject: LongReadLen, lengthb() and Oracle Hi Folks The DBI doc

Re: LongReadLen, lengthb() and Oracle

2005-12-14 Thread Ron Savage
On Wed, 14 Dec 2005 13:10:50 +0100, Peter J. Holzer wrote: Hi Peter > select dbms_lob.getlength(lob_column) as length from table ... > to get the size of a LOB. Thanx, but that didn't work either. Perhaps getlength() has the same restrictions as lengthb()? This is in SQL/Plus: SQL> select dbms

RE: Oracle 10g + Linux RHEL 4 + Perl + DBI = OCIEnvNlsCreate Error (!?!?)

2005-12-14 Thread Reidy, Ron
I googled and found this: http://www.google.com/search?q=ERROR+OCIEnvNlsCreate&sourceid=mozilla-se arch&start=0&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla: en-US:official Can you run a simple script from the command line as: 1. Yourself? 2. The owner of the Apache software? Ch

Oracle 10g + Linux RHEL 4 + Perl + DBI = OCIEnvNlsCreate Error (!?!?)

2005-12-14 Thread DBA FARMASA
Hi fellows. I'm banging my head on this problem for a month, and posted on London PM without a good clue. Maybe you folks can help me a little bit more. I need to connect Best Pratical's RT 3.4.4 to an Oracle 10g Database running on the same box. I'm using the mod_perl 1.29 and apache 1.3.3

ANNOUNCE DBI-1.50

2005-12-14 Thread Tim Bunce
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.50.tar.gz size: 386513 bytes md5: 487cb22f89ab21029725eb6e0b861a2a =head2 Changes in DBI 1.50 (svn rev 2307), 13 December 2005 Fixed Makefile.PL options for gcc bug introduced in 1.49. Fixed handle magic order to keep DBD::Oracle happy. Fixed

Re: LongReadLen, lengthb() and Oracle

2005-12-14 Thread Tim Bunce
I don't know where the LENGTHB suggestion came from, but I'll fix it. Thanks. Tim. On Wed, Dec 14, 2005 at 01:10:50PM +0100, Peter J. Holzer wrote: > On 2005-12-14 11:38:56 +1100, Ron Savage wrote: > > The DBI docs for LongReadLen say to use LENGTHB() for Oracle, but that > > gives me > > an err

Re: LongReadLen, lengthb() and Oracle

2005-12-14 Thread Peter J. Holzer
On 2005-12-14 11:38:56 +1100, Ron Savage wrote: > The DBI docs for LongReadLen say to use LENGTHB() for Oracle, but that gives > me > an error: > > ORA-00932: inconsistent datatypes: expected NUMBER got LONG The SQL reference manual says: char can be any of the datatypes CHAR, VARCHAR2, NCHAR,