Home » SQL & PL/SQL » SQL & PL/SQL » Write to file, send to email and pause...
Write to file, send to email and pause... [message #341940] Wed, 20 August 2008 16:02 Go to next message
ada26
Messages: 15
Registered: September 2007
Location: cleveland
Junior Member
I have a procedure that writes to a file and sends as an email attachment.

This procedure uses FOR LOOP, the goal is to get the distinct EMP ID, LOOP and his REFERENCE NUMBER, LOOPS again gets all his record on table and WRITES to file and SEND to EMAIL.

I have a total of 1,700 files to send to each EMP, however our Email Administrator told me they could not accomodate to send emails that much, they were afraid our email server would crash.

So I have to rewrite my procedure and use a DELAY option.. Is that possible to put the DELAY option on my code? Let say send 100 email and pause for 10 mins and so on..

Is this possible to write on the query?

Re: Write to file, send to email and pause... [message #341941 is a reply to message #341940] Wed, 20 August 2008 16:04 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
SQL> DESC DBMS_LOCK
Previous Topic: Row-wise comparison
Next Topic: Need Help on average and sort
Goto Forum:
  


Current Time: Fri Dec 02 14:17:13 CST 2016

Total time taken to generate the page: 0.05440 seconds