Re: Report6i: Order by CLOB column?
Date: Thu, 8 Jan 2004 17:28:42 -0500
Message-ID: <VJydnWPsKdwDRGCi4p2dnA_at_comcast.com>
"Tiago Rocha" <please.see.link.at.signature.for.email.address_at_zaz.com.br>
wrote in message news:2i4rvvgmg5grioo2j5okv01gclvk61qogn_at_4ax.com...
| 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
sorry -- i grabbed my example from a BLOB (the document upload table used by the PL/SQL gateway)
CLOB doesn't need the utl_raw conversion
- mcs