Re: How to convert LONG to VARCHAR2

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Sat, 13 Apr 2013 18:35:32 -0300
Message-ID: <CAJdDhaOhzzu=n6bTVc0vL5T0ayBUcto4RZ=KK=0+i5EpfGH0sQ_at_mail.gmail.com>

Great Mark,
This solution is easy to use.
Thanks a lot.
Eriovaldo

On Sat, Apr 13, 2013 at 3:58 AM, Sayan Malakshinov <xt.and.r_at_gmail.com>wrote:

> Mark,
>
> I think that working with "long" datatype was simply not provided, since
> it was deprecated already.
>
>
> On Sat, Apr 13, 2013 at 3:15 AM, Mark W. Farnham <mwf_at_rsiz.com> wrote:
>
>> Is that a hard limit, or is there a default maximum for LONG as a session
>> variable as it is in sqlplus and sqlplus copy command?
>>
>> -----Original Message-----
>> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org
>> ]
>> On Behalf Of Sayan Malakshinov
>> Sent: Friday, April 12, 2013 4:06 PM
>> To: David Fitzjarrell
>> Cc: ecandrietta_at_gmail.com; ORACLE-L
>> Subject: Re: How to convert LONG to VARCHAR2
>>
>> Just one note: dbms_xmlgen.getXMLtype truncates "LONG" columns to 4000
>> bytes, although it works fine with clob
>>
>> --
>> Best regards,
>> Sayan Malakshinov
>> Senior performance tuning engineer
>> PSBank
>> http://orasql.org
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>
> --
> Best regards,
> Sayan Malakshinov
> Senior performance tuning engineer
> PSBank
> http://orasql.org
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Apr 13 2013 - 23:35:32 CEST