Thanks, but although the compilation might be an issue, I actually managed to get it to work.
I was using Apache mod_perl (didn't mention that before because I didn't think it was an issue -- silly me!), and stashing the database handle and statement handles in a package so they'd be cached, a la the last example on this page: http://www.saturn5.com/~jwb/dbi-performance.html Well, I ran a test script that just used DBI the old-fashioned way with no packages: connect, prepare the query, execute, and fetch...and it gave me the LONG column just fine. So I started looking more closely at my mod_perl script, and decided that instead of slapping the LongReadLen attribute on the instance of the $dbh or $sth in the calling program (which may be, and probably is, cached from an earlier run), I'd try putting it on the initial connect inside the package, under the assumption that the cached database or statement handle couldn't be changed by the calling program. Bingo -- that worked. I'm relatively new to mod_perl, so I'm still learning all the nuances of how it's different from "normal" Perl. Thanks again, --Tina --- "Sterin, Ilya" <[EMAIL PROTECTED]> wrote: > Well, your DBD::Oracle was compiled with OCI7, so you must recompile. > If you are retrieving values from Oracle 7* db, then you'll have to use > blob_read function, to fetch in chunks, since the support for > LongReadLen is only available with OCI8 compiled DBDs. > > Ilya > > > -----Original Message----- > > From: Tina Mancuso [mailto:[EMAIL PROTECTED]] > > Sent: Monday, June 03, 2002 2:52 PM > > To: [EMAIL PROTECTED] > > Subject: Truncated LONG values from Oracle > > <snip> > > I am trying to fetch a column with datatype LONG using DBI > > version 1.23, Oracle DBD version 1.12, Oracle client v8.1.7, > > and Oracle server 7.3.4. I know that the value inserted into > > the column is intact, about 500 bytes, because I can select > > it using SQL*Plus, but every time I try to fetch the column > > with DBI, it gets truncated to 80 characters. ===== [EMAIL PROTECTED], [EMAIL PROTECTED] http://www.monster-island.org __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com
