RE: ora-01458

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Fri, 28 Apr 2000 10:20:10 -0400
Message-Id: <10481.104427@fatcity.com>

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_at_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_at_gmd.fujitsu.com

kimberly.smith_at_eds.com

------_=_NextPart_001_01BFB11C.DCBD8E30
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>RE: ora-01458</TITLE>
</HEAD>
<BODY>

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 [<A =
HREF=3D"mailto:KSMITH1_at_gmd.fujitsu.com">mailto:KSMITH1_at_gmd.fujitsu.com</= A>]
 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_at_gmd.fujitsu.com
         kimberly.smith_at_eds.com Received on Fri Apr 28 2000 - 09:20:10 CDT