Re: how to copy data from long to varchar2

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 03 Nov 2006 09:17:30 +0100
Message-ID: <eidoqo$e1$1@news4.zwoll1.ov.home.nl>

Martin T. schreef:
> Peter Keckeis wrote:

>>
>> create table test (pk char(6),  vc_txt  varchar2(2000), l_txt long,
>> constraint testpk primary key(pk))
>>
>> generates an  ORA-00932 error.

>
> You might want to post your Oracle version when asking around here :)
>

Must be pre-8.0, because Oracle advertises to use LOB's, not longs since the end of 7.3. The use of char(6) as primary key also makes me wonder.

And when were varchar2(4000) columns introduced?

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Fri Nov 03 2006 - 02:17:30 CST