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>...
>
>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.
>
>
>
Received on Wed Dec 02 1998 - 00:00:00 CST
