Shell Programming and Scripting

hi frnds,

I have my data file as belw

Code:

STN,STO,aabbccccc.....zz,STP
STN,STO,aabbccccc.....zz,STP
STN,STO,aabbccccc.....zz,STP

while am using sql loader to load all the data in the data file its not loading into table and throw error as 3rd filed length so long. but i hav the DB filed with more than enough length.

if i reduce the length of 3rd filed , its getting loaded.

whats the problem? any one can give solution? is the any lenth limitation in unix assigning values to variable ?
plz give me a resolution

I think it is definitely not due to OS problem. Can you tell us 3rd field length and size of that column in the table.

Code:

the 3rd fileds has around 1500 characters in it

Plz sugg me some solution which helps to insert the records very fast manner
becaze the if am not using sql loader , if i use normal sql plus , its inserting but talking time around 1.30 mins

plz suggest some helpful ways

Hi Gopal,
As luckybalaji says, unix isn't producing this error. You appear to be encountering a limitation of your sql loader instead or the database's field limit is too short.

I would suggest doing a single manual import of one line using a more robust tool to test the database limit.
If that works correctly, replace your sql loader.