Welcome Guest ( Log In | Register )



Performance Tuning Reference poster
Oracle training in Linux 

Oracle training Weblogic Book
Easy Oracle Jumpstart
Oracle training & performance tuning books
Burleson Consulting Remote DB Administration
Reply to this topicStart new topic
> Run Oracle Report and Email, Run Oracle Report and Email
Nagaraj R
post Feb 28 2017, 12:15 PM
Post #1


Group: Members
Posts: 1
Joined: 28-February 17
Member No.: 51,810

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.


Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


Lo-Fi Version Time is now: 20th October 2017 - 04:32 PM