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.