Hi Experts,
We have a plsql package where we have bulk logic. Here, we are generating a csv file from a cursor query. Here, we are generating a single file for all the data. Now, we have a requirement where we need to generate multiple files grouping by Supplier-Org.
Can anyone please help me on how to generate multiple files grouping by Supplier-Org, in PLSQL Package.
Please note, now, I cannot go with any other approach (like bursting program etc.,). I need to use the same package for changes to generate multiple files.
Attached the sample plsql package we are using for reference.
Thanks in Advance,
Bommi
sundry_purchases.sql