Re: Getting a sub-clob

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