How to create dynamic folder on the server using plsql package and zip that folder

Hi All,

I have a requirement where I need to create a ap invoice extract in invoice.csv file and also pull attachments for those invoices on the server . I need to zip the invoice.csv along with the attachments and send to the vendor.

I have 2 questions related to plsql

1) How do I create a dynamic folder on the server using plsql package .

2) How do I zip that folder using plsql package.

Thanks

Anuja