Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

fnd_file.put_line(FND_FILE.OUTPUT in Ora Apps in SQL*Plus program

664563Nov 12 2008 — edited Nov 12 2008
I have used fnd_file.put_line(FND_FILE.OUTPUT and fnd_file.put_line(FND_FILE.LOG many times for programs registered as PL/SQL Stored Procedure or used in DB Packages to write to the concurrent manager output and log files. No problem doing that. I have a simple program that I was going to register in Oracle Apps as a SQL*Plus script (instead of creating a DB procedure) that contains a PL/SQL block and will use fnd_file.put_line to write the output so it can be seen from the Concurrent Mgr View Requests. When the script runs the fnd_file.put_line(FND_FILE.OUTPUT... doesn't write to the output (or log) file. I am guessing fnd_file.put_line(FND_FILE.OUTPUT is not available to programs registered as SQL*PLUS.

Is that correct? Am I missing something simple that would allow it to run without creating a DB procedure/package.

I am testing this with a very simple script just to see if I can get something written to the output and log files.

SET SERVEROUTPUT ON

declare
x varchar2(20);
Begin
select 'test'
into x
from dual;
fnd_file.put_line(FND_FILE.LOG,'In the log file');
fnd_file.put_line(FND_FILE.OUTPUT,'In the output file');
end;


Thanks for taking the time to read this and any offers to help
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 10 2008
Added on Nov 12 2008
4 comments
20,126 views