Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Extracting the size of an Oracle LONG data type

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@news.seed.net.tw>#1/1

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 Tue Dec 01 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US