DBMS_LOB.SUBSTR(clob, amount default 32767, start_position default 1)
should do the trick. clob must be a valid LOB locator, amount is between 1
and 32767 and start_position can be anything you want to be substring start
position. If you omit amount and start_position, defaults will be used and up
to 32K of the CLOB content will be returned (or whole content, if it's less than
32K.)
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Michael Baumgartner" <michael_at_mcbaumi.de> wrote in message
news:anvl3l$11q0$1_at_fluffy.foo.fh-furtwangen.de...
> how can I convert (cast) a clob- field to varchar2
>
> 'a string/ varchar2'|| TO_CHAR(clob_field)
> couses an error (different datatype)
>
> (oracle 8i)
>
> michael
>
>
Received on Wed Oct 09 2002 - 02:23:36 CDT
