Re: LONG DATATYPE

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 03 Nov 1998 18:46:45 GMT
Message-ID: <36464f7f.20024033@192.86.155.100>

A copy of this was sent to Jason Jay Weiland <archduke_at_uclink4.berkeley.edu> (if that email address didn't require changing) On Tue, 03 Nov 1998 10:33:21 -0800, you wrote:

>Thomas,
>
> I thought that you would have to use
>DBMS_SQL.COLUMN_VALUE_LONG to pull out the
>value and assign it to a VARCHAR before you
>could use SUBSTR...
>

Nope -- pl/sql defines the subtype LONG to be varchar2(32760) -- it does the implicit conversion to a VARCHAR for you but will fail for longs > 32k...

>Jay!!!
>
>
>Thomas Kyte wrote:
>
>> A copy of this was sent to D S Tharpe <i5t_at_ornl.gov>
>> (if that email address didn't require changing)
>> On Tue, 03 Nov 1998 11:05:39 -0500, you wrote:
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Nov 03 1998 - 12:46:45 CST