Regarding importing of data

[aakn30]

Dear friend,

I need to import text file into oracle .I am using oracle 10g.
The text file contains blank space for some lines and
the next line (which is having data )appear some 10 lines after that.
The full text file is pertaining to only one field in my table and which is described as "long" field.

Please help me regarding that. Is there any web utility to do that.

Yesterday i have installed oraloader (one utility which is a trial version)
and it is working fine.But it is importing blank lines also.
I dont want blank lines.

[febyfelix]

you can use the UTL_FILe in oracle. search for UTL_FILE in google and you will get realtime examples.

[aakn30]

you can use the UTL_FILe in oracle. search for UTL_FILE in google and you will get realtime examples.

thanks for your feedback. i will try and let u know the result

[febyfelix]

if any problem occurs u can post it here...
regards,
feby felix mathew