On 2010-04-20 09:50:48 -0400, Martin Gainty wrote:
some confusion on the oracle documentation
http://www.scribd.com/doc/21329014/Oracle10g-Develop-PLSQL-Program-Units-VOL2
which states
CLOB Datatypes is for single byte character stream
NCLOB is multibyte character stream based upon byte
Hi,
I'm using DBI 1.608, DBD::Oracle 1.23, OCI from 10.2.0.2. I'm trying to select
a CLOB having prepared my select using ora_pers_lob = 1. I've also got the
following options set on my DB handle:
LongReadLen = 100 * 1024,
LongTruncOk = 1,
No you are not missing 64k seems to be the limit for that interface with
Clobs and it is a Historical Oracle limit not Perl limit.
in DBD::ORacle 1.24
http://search.cpan.org/~pythian/DBD-Oracle-1.24a/Oracle.pm#Simple_Fetch_for_CLOBs_and_BLOBs
I say the following
For CLOBs and NCLOBs the
James Hooker wrote:
Thanks for the info John.
The following statement is the part confusing me:
However if you CLOB is longer than this and also larger than the
'LongReadLen' than the 'LongReadLen' in chars is returned.
Funny thing took me a while to figure this one out at well. Has to do
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
Date: Tue, 20 Apr 2010 09:28:14 -0400
From: sco...@pythian.com
To: jimhooker2...@yahoo.co.uk
CC: dbi-users@perl.org
Subject: Re: CLOB select with ora_pers_lob (truncation issue)
James
Thanks for the info John.
The following statement is the part confusing me:
However if you CLOB is longer than this and also larger than the 'LongReadLen'
than the 'LongReadLen' in chars is returned.
For my example the CLOB is longer than LongReadLen (which in turn is longer
than 64K). So