-
query
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.
ramya
-
"acc"? Why the flat file and java requirement?
-
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.
ramya
-
You could use "utl_file"
Oracle Reference
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.
Oracle DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|