I would like a user initiate the process of running reports and emailing them.
From oracle forms user presses a button to initiate email process. Once initiated i need the following to happen.
I need to run 90 oracle reports in the background generated as a pdf file.
I need to capture the location and name of the report generated.
i need to email each report pdf generated to a requester(the email address of the requester will come from the database).
I am posting this in Oracle forum under the assumption that this will be done via stored procs/db triggers
How do i go about achieving this
I am using Oracle 12c and fushion middleware 12c on unix solaris.