query

[rumcool]

Hi all,
I want to create a procedure which validates the data acc to the business rule and generate a text file (fixed field format) which inturn the java scheduler calls for further process.
i tried using dbms_sql.define_columns , descibe_columns but the output doesnt give the fixed format ...is there any function which can do so in dbms_sql.

or is there any other way to do so ?

thanks in advance.

[slimdave]

"acc"? Why the flat file and java requirement?

[rumcool]

hi,
The requirement is that u get cutomer_info from the cutomers in different formats ,and load the data in db . and do some validations , chks(chking the nearest dealer ....etc) and again convert back to the different formats accordingly.java class shall invoke ftp to transfer local files to secured targets.

[simply_dba]

You could use "utl_file"
Oracle Reference