Re: Getting a sub-clob

In article <3CAE3DCE.D72030EF_at_exesolutions.com>, damorgan says...
>
>4000 for VARCHARs in a table. 32K in the variable.
>
>Daniel Morgan
>

not really (being technical here) --- 4000 in SQL, 32k in PLSQL (its not a table vs a variable -- its a language vs a language)

Here, we are dealing with SQL so the limit is in fact 4000 regardless. A SQL query will not return a 4001 byte varchar2.

>
>
>Thomas Kyte wrote:
>
>> In article <5640b938.0204050923.153365d3_at_posting.google.com>,
>> beautiful_idiot_at_yahoo.com says...
>> >
>> >I'd like to do the following:
>> >
>> >select DBMS_LOB.substr(dna_raw_sequence,400,1) from dna_sequence where
>> >dna_sequence_id =7000000000506637
>> >
>> >Except have it work on substrings up to the full length of the clob.
>> >
>> >The above works wonderfully as long as you don't go beyond the
>> >varchar2 limit.
>> >
>> >And I'd really like it if I didn't have to write any PL/SQL but could
>> >just use an existing function.
>> >
>> >No luck after a morning of poking through the docs, google groups, and
>> >bugging local dba.
>> >
>> >Thanks in advance!
>>
>> The limit is the limit - for varchar2 - 4000, raw/char -- 2000.
>>
>>What is the client? why cannot the client get the entire LOB and get the pieces
>> it wants using the API's that work on LOBS?
>>
>> --
>> Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/
>> Expert one on one Oracle, programming techniques and solutions for Oracle.
>> http://www.amazon.com/exec/obidos/ASIN/1861004826/
>> Opinions are mine and do not necessarily reflect those of Oracle Corp
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp