ora-01458

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Wed, 26 Apr 2000 19:10:03 -0400
Message-Id: <10479.104238@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_01BFAFD4.8EDFC8C0
Content-Type: text/plain;

charset="iso-8859-1"

I am trying to execute script in sqlplus

set long 80000

delete from ref_cpt;
commit;

copy from demo01/demo_at_sdedbs02 insert ref_cpt using select * from ref_cpt;

exit

It gives me error ora-01458.

Cause: An attempt was made to bind or define a variable character string with a buffer length less than the minimum requirement.

Action: Increase the buffer size or use a different type.

This table has one column with long datatype.

Any ideas pleas

------_=_NextPart_001_01BFAFD4.8EDFC8C0
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>ora-01458</TITLE>
</HEAD>
<BODY>

I am trying to execute script in =
sqlplus


set long 80000


delete from ref_cpt;
 commit;


copy from demo01/demo_at_sdedbs02 insert =
ref_cpt using select * from ref_cpt;


exit


It gives me error ora-01458.


Cause: An attempt =
was made to bind or define a variable character string with a buffer = length less than the minimum  requirement.

  Action: =
Increase the buffer size or use a different type. 


This table has one =
column with long datatype.

 

Any ideas pleas
Received on Wed Apr 26 2000 - 18:10:03 CDT