Size of LONG (bigger than 32K)

From: Rick Osterberg <osterber_at_fas.harvard.edu>
Date: Thu, 1 Jun 2000 10:46:52 -0400 (EDT)
Message-Id: <10515.107397@fatcity.com>

I know it's possible to get a size of a LONG field in a row using the PL/SQL block to read it into a variable, and then take the LENGTH() of that variable. But due to PL/SQL limitations, that only works to lengths of 32K. Is there any way to determine the size of a LONG field if it's longer than 32K?

-Rick

+--------------------------------------------------------------------------+

|                 Rick Osterberg   osterber_at_fas.harvard.edu                |
|         Database Applications Specialist     FAS Computer Services       |


+--------------------------------------------------------------------------+

Received on Thu Jun 01 2000 - 09:46:52 CDT