Re: Help

["Chugani, Manju (Computer Enterprises Inc at Alcoa)" <Manju.Chugani@ALCOA.COM>]

Hi Alok ,
Thanks for your response .
 I am not geting the  value from the data file . I am getting the value from the customer table & inserting it in one of the tmp table .
I used the funtion length in SQR ,it shows me the length to be 30 of that variable .
And the best part of all this is - it works fine when I try to run the same program in Windows .
Manju Chugani
E-Mail: Manju.Chugani@alcoa.com
PHONE: (412) 553-5675
b

----------
From:   Kulshrestha, Alok[SMTP:ALOKKULSHRESTHA@IMF.ORG]
Reply To:       SQR-USERS@USA.NET
Sent:   Friday, October 23, 1998 11:48 AM
To:     Multiple recipients of list SQR-USERS
Subject:        Re: Help

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