Re: Extracting the size of an Oracle LONG data type
From: Daniel Clamage <dclamageNOSPAM_at_telerama.com>
Date: 1998/12/02
Message-ID: <366617dc.0_at_paperboy.telerama.com>#1/1
Date: 1998/12/02
Message-ID: <366617dc.0_at_paperboy.telerama.com>#1/1
Use DBMS_SQL.column_value_long to fetch bite-size chunks of the long and track the cumulative lengths.
-- - Dan Clamage http://www.telerama.com/~dclamage If you haven't crashed the Server, you haven't been trying hard enough. fumi wrote in message <74356e$12$1_at_news.seed.net.tw>...Received on Wed Dec 02 1998 - 00:00:00 CET
>
>Sybrand Bakker ¼¶¼g©ó¤å³¹ <3663A64A.4AB6C1A3_at_sybrandb.demon.nl>...
>>select vsize(<expression>)
>>from table
>>should do it
>
>
>It would not work.
>The LONG column can't be a parameter of SQL functions.
>
>I use VB with Oracle object for OLE, ODBC API. There is a method of the
>OraField
>object called FieldSize. This method will return the number of bytes
stored
>in the LONG
>or LONG RAW column, but it will return -1 if the size is more than 64K.
So,
>we use
>another column to store the size of the LONG column.
>
>
>