Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Scheduling Reports (APEX 3.2)
Scheduling Reports [message #400800] Wed, 29 April 2009 12:07 Go to next message
RickyC
Messages: 4
Registered: April 2009
Junior Member
Hi,

I would like to know if it's possible to create a report and send the result of that report by mail using the oracle scheduler?

If it's possible, how do i do this.

Thanks in advance
Re: Scheduling Reports [message #401535 is a reply to message #400800] Tue, 05 May 2009 07:44 Go to previous message
c_stenersen
Messages: 255
Registered: August 2007
Senior Member
Sure. Create a procedure which makes a varchar2 with a list of your data in whichever format you want it shown in. Then send the list using utl_mail. Schedule the procedure to be run by using dbms_scheduler.
Previous Topic: difficult to import application in Appex-3.2
Next Topic: Passing varrays to external procedures
Goto Forum:
  


Current Time: Thu Mar 28 17:23:03 CDT 2024