Re: Getting the size of an Oracle LONG
From: Daniel Clamage <dclamageNOSPAM_at_telerama.com>
Date: 1998/12/05
Message-ID: <3668ebc5.0_at_paperboy.telerama.com>#1/1
Date: 1998/12/05
Message-ID: <3668ebc5.0_at_paperboy.telerama.com>#1/1
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>...Received on Sat Dec 05 1998 - 00:00:00 CET
>Check my answer to fumi's question...
>You can get the size of a long column using utl_raw.length
>
>
>