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

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: 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.

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: Thu Aug 18 18:52:38 CDT 2022
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.