Concurrent program to write a file in apps server
We are in 11.5.10.2 apps and 10g database. Apps is in apps Linux server and database is in database linux server ( 2 nodes ).
I create a concurrent program. It is required to create one output with specify file name and the file must save in some other directory in the apps server.
Since the database is in different linux box, if I use UTL_FILE.FOPEN, it will create the file in database linux server. I like the file is created in apps server. I also cannot use the apps.fnd_file.put(apps.fnd_file.output, 'ABC...') because it will write to the standard output file which name like o123456.out. the file name must be called file_14JUL2015_120132.txt ( file name include current date and time )