fnd_file calling through concurrent request not working.
Hi,
We are calling below sql through a concurrent request.
===
[appltest4@tvlap73 sql]$ cat KCLSQL1.sql
SET SERVEROUTPUT on
set head off
set pages 0
set lines 600
set trimspool on
DECLARE
BEGIN
fnd_file.put_line(fnd_file.output,'KCL Testing);
fnd_file.put_line(fnd_file.log,'KCL');
fnd_file.put_line(fnd_file.log,'SQL');
fnd_file.put_line(fnd_file.log,'TEST');
END;
/
============
The expected results are...
In concurrent request log file it should print the fnd_file.log entries as "KCL","SQL","TEST". And In Concurrent request output file it should print "KCL Testing".
But in my case both are not happening. At DB level we verified APPLPTMP, utl_file_dir values are fine.
We are calling below sql through a concurrent request.
===
[appltest4@tvlap73 sql]$ cat KCLSQL1.sql
SET SERVEROUTPUT on
set head off
set pages 0
set lines 600
set trimspool on
DECLARE
BEGIN
fnd_file.put_line(fnd_file.output,'KCL Testing);
fnd_file.put_line(fnd_file.log,'KCL');
fnd_file.put_line(fnd_file.log,'SQL');
fnd_file.put_line(fnd_file.log,'TEST');
END;
/
============
The expected results are...
In concurrent request log file it should print the fnd_file.log entries as "KCL","SQL","TEST". And In Concurrent request output file it should print "KCL Testing".
But in my case both are not happening. At DB level we verified APPLPTMP, utl_file_dir values are fine.
0