Re: Help

["Kulshrestha, Alok" <ALOKKULSHRESTHA@IMF.ORG>]

Manju,

I guess the DATA STRING has some non-display characters in the string. May
be this field is the last field in the  line and has linefeed, embedded
carriage return etc. If you can open the datafile in editor where
non-display character is visible, may help you in finding out this.

I would suggest you to trim the string with the following characters

        Let $datastring = rtrim(ltrim($datastring,char(13)))            !
for embedded carriage returns
        Let $datastring = rtrim(ltrim($datastring,char(10)))            !
For linefeed

!    For End-of the file, I guess char(26)

Hope it helps you...
-alok

On Friday, October 23, 1998 11:10 AM, Chugani, Manju (Computer Enterprises
Inc at Alcoa) [SMTP:Manju.Chugani@ALCOA.COM] wrote:
: Hi ,
:
: In SQR program when I try to run thru UNIX - I am getting an error - when
I
: am trying to insert a 30 char value in field that is being defined as 40
: varchar2 .
: If I update the value to 29 chars it does not give any errors .
:
: The error is :  ORA-01461: can bind a LONG value only for insert into a
: LONG column
:
: But I don't get any errors when I try to run the same program thru Client
: (SQRW) .
:
: Database being used-  Oracle 8.0
:
: Thanks ,
:
:
: Manju Chugani
: E-Mail: Manju.Chugani@alcoa.com
: PHONE: (412) 553-5675
: b