Re: Report6i: Order by CLOB column?

[Quoted] On Thu, 8 Jan 2004 10:51:28 -0500, "Mark C. Stock" <mcstockX_at_Xenquery .com> wrote:

>however, you can order by wrapping the CLOB in UTL_RAW.CAST_TO_VARCHAR2(
>DBMS_LOB.SUBSTR( ) ) calls -- and limiting the length of the substring to
>the number of characters that would be significant in the sort

When trying to use utl_raw, it gave me ORA-6502... But I just removed the utl_raw and used just dbms_lob.substr and it worked great!

Thanks!

-- 
Tiago Rocha
Recife - Brasil
www.diariodastrilhas.cjb.net