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.
"acc"? Why the flat file and java requirement?
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.
You could use "utl_file"
There are three kinds of lies: Lies, damned lies, and benchmarks...
Unix is user friendly. It's just very particular about who it's friends are.
Click Here to Expand Forum to Full Width