Getting a sub-clob

From: Reinhard Engels <beautiful_idiot_at_yahoo.com>
Date: 5 Apr 2002 09:23:47 -0800
Message-ID: <5640b938.0204050923.153365d3@posting.google.com>

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! Received on Fri Apr 05 2002 - 11:23:47 CST