Members   Search   Help    Register    Login   Home
Home » Developer & Programmer » Application Express & MOD_PLSQL » Scheduling Reports (APEX 3.2)
Scheduling Reports [message #400800] Wed, 29 April 2009 12:07 Go to next message
RickyC
Messages: 1
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
Report message to a moderator
Re: Scheduling Reports [message #401535 is a reply to message #400800] Tue, 05 May 2009 07:44 Go to previous message
c_stenersen
Messages: 89
Registered: August 2007
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.
Report message to a moderator
Previous Topic:difficult to import application in Appex-3.2
Next Topic:Passing varrays to external procedures
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 8 15:40:43 CST 2009

Total time taken to generate the page: 3.87402 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.