Hello,
I have a PL/SQL package where I need to spool output to various client-side folders/files.
In general, I realize I can use something like this:
set serveroutput on;
spool C:\Temp\spoolTest.txt;
exec myPackage.mainProc;
spool off;
However, within this package, I need the output to spool to different folders/files based on system requirements.
Is there a way to accomplish this using spool? I am guessing we cannot change the spool file name on the fly within the PL/SQL. Is there another approach we can use instead?
Thank you!
Dennis