fnd_file.put_line(FND_FILE.OUTPUT in Ora Apps in SQL*Plus program
664563Nov 12 2008 — edited Nov 12 2008I 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