Re: Getting the size of an Oracle LONG

A PL/SQL RAW is limited to 32767 bytes, so using utl_raw.length on a long variable (which also is limited to 32KB) won't help you for LONGs bigger than 32K.

You will have to use DBMS_SQL.column_value_long to do piecewise fetches and accumulate the lengths of each chunk.

--
- Dan Clamage
http://www.telerama.com/~dclamage
If you haven't crashed the Server,
you haven't been trying hard enough.
Marcus Voltis Bulach wrote in message
<749fqt$ebp$1_at_iguacu.dcc.unicamp.br>...


>Check my answer to fumi's question...

>You can get the size of a long column using utl_raw.length

>

>

>