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
Messages: 4
Registered: April 2009
Junior Member

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
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 Aug 18 18:52:38 CDT 2022