Writing to oracle logfile from unix shell script? -
i having oracle concurrent program calls unix shell script execute sql loader program. used inserting flat file legacy oracle base tables.
my question here is,
how capture custom messages, validation error messages etc in oracle log file of concurrent program.
all in regards appreciated.
it looks trying launch sql*loader oracle apps. simplest way use sql*loader type of executables, way output , log files right in concurrent requests window.
if want write in log file , output file unix script, can find them in fnd_concurrent_requests table (column logfile_name
, outfile_name
). should request_id passed parameter script.
these files should in $xx_top\log
, should called l{request_id}.req
, o{request_id}.out
(apps 11.5.10).
Comments
Post a Comment