RE: How to convert LONG to VARCHAR2
From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Fri, 12 Apr 2013 19:15:32 -0400
Message-ID: <042601ce37d3$a29feca0$e7dfc5e0$_at_rsiz.com>
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?
Date: Fri, 12 Apr 2013 19:15:32 -0400
Message-ID: <042601ce37d3$a29feca0$e7dfc5e0$_at_rsiz.com>
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
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Apr 13 2013 - 01:15:32 CEST