Questions
Gh, February 24, 2018 - 7:25 am UTC
Where comes from dump_ot?
Why function not procedure?
Why pipelined?
Why open and close file are in loop?
separe file for each record using parallel function
naveen mani, February 26, 2018 - 4:02 am UTC
the ask is to create separate files for each record of the drive query. these separate file will be sent to unix software for further processing.
February 27, 2018 - 1:48 am UTC
In that case, I would look at using something like
DBMS_PARALLEL_EXECUTE
Search this site for that and there's plenty of examples