Re: Extracting the size of an Oracle LONG data type
From: fumi <fumi__at_tpts5.seed.net.tw>
Date: 1998/12/01
Message-ID: <74356e$12$1_at_news.seed.net.tw>#1/1
Date: 1998/12/01
Message-ID: <74356e$12$1_at_news.seed.net.tw>#1/1
[Quoted] 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
[Quoted] or LONG RAW column, but it will return -1 if the size is more than 64K. So,
we use
[Quoted] another column to store the size of the LONG column.
Received on Tue Dec 01 1998 - 00:00:00 CET