LONG columns - question

From: Vladimir Barac - posao <vbarac_at_dkts.co.yu>
Date: Thu, 4 May 2000 08:19:23 +0200
Message-Id: <10486.104901@fatcity.com>

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

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 "<column value = 1>","<column value 2>",... Note that " and , and <columna value> 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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>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.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Here is the situation:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>- 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.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>- using SQL*Plus and spooling and =
concatenations=20
everything works like charm, except...</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>- LONG column cannot be concatenated =
(error saying=20
about "incosistent datatypes".</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>So, what can I do to dump content of a =
table having=20
long column?</FONT></DIV></BODY></HTML> Received on Thu May 04 2000 - 01:19:23 CDT