Hi all,

I've a situation where in am to load the data from a custom file into a table using oracle 9i(not supposed to use later versions). the file format is given below.

@col1 = col1_value,@col2 = col2_value,@col3 = col3_value,@col4 = col4_value
@col1 = col1_value,@col2 = col2_value,@col3 = col3_value,@col4 = col4_value
@col1 = col1_value,@col2 = col2_value,@col3 = col3_value,@col4 = col4_value
@col1 = col1_value,@col2 = col2_value,@col3 = col3_value,@col4 = col4_value

The data after loading and validating using a custom procedure, needs to be exported to a xml file.
Please help me out.

Since you are going OS text file to OS text file, why get Oracle involved at all.
This could be done using PERL with a simple custom converted code.

thanks for the reply.
but, i cannot use technologies other than oracle. And there are some custom procedures and objects that take data for business from the table loaded from the file.