Re: How to convert LONG to VARCHAR2

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Sat, 13 Apr 2013 10:58:51 +0400
Message-ID: <CAOVevU5+DucK37SZJ3cACfhUfQdP_WFh2qA6Uab+fdjVjybVTg_at_mail.gmail.com>

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 - 08:58:51 CEST