Hello, does any one know how to create this concurrent program? thanks
I think you need to learn basics of concurrent program, please go through below link to start with.
As far as I have understand your problem, you want to create a PL/SQL based concurrent program and use utl_file to write file into a temp dir.
Hello every one, do you know how to create a concurrent program to read from db table (as apps user) and create file in temp dir?
Do we have to hardcorded the apps passwd? appreciate all your help! Thanks
Your want to run a query and get result in file?
You can define concurrent program with sql*plus execution method .
Concurrent Program Execution File
A concurrent program execution file is an operating system file or database stored procedure which contains your application logic and can be executed by either invoking it directly on the command line or by invoking a program which acts upon it. For example, you run a Pro*C program by invoking it on the command line. You run a SQL script by running SQL*Plus and passing the name of the SQL script without the .sql extension.
How to Run an .sql Script as Concurrent Request in E-Business Suite (Doc ID 1575955.1)
Once defined the system will take care of running the script and giving you output on Submit Request Screen(SRS)