Re: How to convert LONG to VARCHAR2
- From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
- To: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
- Date: Sat, 13 Apr 2013 18:35:32 -0300
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@xxxxxxxxx>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@xxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx
>> ]
>> On Behalf Of Sayan Malakshinov
>> Sent: Friday, April 12, 2013 4:06 PM
>> To: David Fitzjarrell
>> Cc: ecandrietta@xxxxxxxxx; 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
>>
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>
> --
> Best regards,
> Sayan Malakshinov
> Senior performance tuning engineer
> PSBank
> http://orasql.org
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
