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
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
Messages: 25571
Registered: January 2009
Location: SoCal
Senior Member
Previous Topic: Row-wise comparison
Next Topic: Can i do this in a Single query
Goto Forum:

Current Time: Sat Aug 19 11:54:43 CDT 2017

Total time taken to generate the page: 0.06101 seconds