Message-Id: <10481.104427@fatcity.com> From: Alex Hillman Date: Fri, 28 Apr 2000 10:20:10 -0400 Subject: RE: ora-01458 This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFB11C.DCBD8E30 Content-Type: text/plain; charset="iso-8859-1" Are wou reading messages before replying. Maybe you should RTFM instead of advicing other. COPY command in SQLPLUS according to FM can handle LONG datatype. There are specific parameters in SQLPLUS which you can set using SET command - like long, longc... My question was why this did not work and gave me ora-01458. Alex Hillman -----Original Message----- From: Kimberly Smith [mailto:KSMITH1@gmd.fujitsu.com] Sent: Thursday, April 27, 2000 10:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: ora-01458 Read up on longs. Can't do that. There is a whole list of things that just cannot be done when dealing with longs. You may be able to write some Pro*C code to do what you want. Well maybe even some PL/SQL as long as the biggest long you have is 32k or less. --------------- Kimberly Smith EDS/Fujitsu Gresham, Oregon Work: 503-669-6050 Email: kimberly.smith@gmd.fujitsu.com kimberly.smith@eds.com ------_=_NextPart_001_01BFB11C.DCBD8E30 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: ora-01458

Are wou reading messages before replying. Maybe you = should RTFM instead of advicing other. COPY command in SQLPLUS = according to FM can handle LONG datatype. There are specific parameters = in SQLPLUS which you can set using SET command - like long, longc... My = question was why this did not work and gave me ora-01458.

Alex Hillman

-----Original Message-----
From: Kimberly Smith [mailto:KSMITH1@gmd.fujitsu.com]
Sent: Thursday, April 27, 2000 10:09 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: ora-01458


Read up on longs.  Can't do that.  There is = a whole
list of things that just cannot be done when = dealing
with longs.  You may be able to write some = Pro*C code
to do what you want.  Well maybe even some = PL/SQL as
long as the biggest long you have is 32k or = less.

---------------
Kimberly Smith
EDS/Fujitsu
Gresham, Oregon
Work:   503-669-6050
Email: kimberly.smith@gmd.fujitsu.com
        kimberly.smith@eds.com