Re: Getting a sub-clob

4000 for VARCHARs in a table. 32K in the variable.

Daniel Morgan

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
Received on Fri Apr 05 2002 - 18:14:07 CST