Oracle Financials

Posted on 2000-05-08
Medium Priority
Last Modified: 2008-02-20

In Oracle Financials 10.7 environment, I am writing a PL/SQL concurrent program. How to write debug information to the output of the concurrent program?
Question by:jyhuang
  • 2

Expert Comment

ID: 2793046
You can use the UTL_FILE procedure to write to files from within PL/SQL. Inorder to write to the concurrent request log and/or output files, you would have to retreive the output and/or log filename from the FND_CONCURRENT_REQUESTS table for the concurrent request of your process (use FND_GLOBAL.request_id to retrieve your concurrent request_id). When you open the output/log files, use the 'append' option since you and the concurrent manager will be writing to the files.

In release 11 this has been changed and you must use the new FND_FILE package.

Note that UTL_FILE requires the utl_file_dir init parameter to be set to the directory where the log/output is being stored. You can put utl_file_dir=* to mean all directories for a test environment.

Hope this helps

Author Comment

ID: 2793123


Thank you very much for the comments. Our system is down, I can't test it. But I will. Just wondering whether the concurrent manager and my program can write to the output file simultaneously even if use "append" option.

By the way, you have to post an answer instead of comment in order for me to give you points.


Accepted Solution

bellyboy earned 400 total points
ID: 2793310

With the append you should be able to write to the output file simultaneously.

I thought you could change my comment to a question. (But I am fairly new to this game)


Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

619 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question