Re: Why is VARCHAR2(4000) bad ?

From: DA Morgan <>
Date: Fri, 25 Jan 2008 20:59:35 -0800
Message-ID: <>

Serge Rielau wrote:
> Walt wrote:

>> Harel wrote:
>>> Questions:
>>> - Since we dont know in advance the size we will really need in the
>>> future, is there a VARCHAR2(*) ?
>> Sort of.  It's called a CLOB, and is the better way to deal with 
>> arbitrarily long strings.  Dealing with CLOBs can be a little tricky 
>> since they're proprietary to Oracle and not standard SQL (i.e. you 
>> can't expect to use them with ODBC etc.) I wouldn't use a CLOB for 
>> this purpose.

> CLOBs are SQL Standard. The DBMS_LOB package (or whatever it is called)
> is not, of course.
> Cheers
> Serge

How long before you build the equivalent of DBMS_LOB into DB2 Serge? I'm betting before the decade is over. That is if you don't want to be reporting to Mark.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Fri Jan 25 2008 - 22:59:35 CST

Original text of this message