Message-Id: <10486.104901@fatcity.com> From: "Vladimir Barac - posao" Date: Thu, 4 May 2000 08:19:23 +0200 Subject: LONG columns - question This is a multi-part message in MIME format. ------=_NextPart_000_00C0_01BFB5A1.744711C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi I have encountered some problems regarding long columns in tables - and = I have read the manuals (about restrictions), so I was aware of = problems. Anyway, workaround will be apreciated. Here is the situation: - I want to dump content of table to ascii file in format "","",... Note that " and , and are = concatenated. - using SQL*Plus and spooling and concatenations everything works like = charm, except... - LONG column cannot be concatenated (error saying about "incosistent = datatypes". So, what can I do to dump content of a table having long column? ------=_NextPart_000_00C0_01BFB5A1.744711C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi
 
I have encountered some problems = regarding long=20 columns in tables - and I have read the manuals (about restrictions), so = I was=20 aware of problems. Anyway, workaround will be apreciated.
 
Here is the situation:
 
- I want to dump content of table to = ascii file in=20 format "<column value 1>","<column value 2>",... Note that " = and ,=20 and <columna value> are concatenated.
 
- using SQL*Plus and spooling and = concatenations=20 everything works like charm, except...
 
- LONG column cannot be concatenated = (error saying=20 about "incosistent datatypes".
 
So, what can I do to dump content of a = table having=20 long column?