How to Email a PDF Report that is called from a procedure
I have a task to create a report/process that will email a .pdf report.
Here is our system specs: Database Server
----------------------------------------
RDBMS : 11.2.0.1.0
Oracle Applications : 12.1.3
Machine : inxx55
User : APPS
Oracle SID : HJDEV
System Date : 06-MAR-2012 09:42:04
Database Server PID : 6686
Session SID : 348
SERIAL# : 3345
AUDSID : 27495952
Database CPU Usage (in secs) : 0.00
----------------------------------------
Forms Server
----------------------------------------
Oracle Forms Version : 10.1.2.3.0
Application Object Library : 12.0.0
I want to know what parameters/ or set up is needed for this.
I have a Concurrent Program, that calls a Package.Procedure, that identifies what orders i want to report, and the email to send to.
I have code to submit the request as follows: