email text files through plsql procedures
746588Jan 14 2010 — edited Jan 14 2010Hi,
I have written a procedure that selects table data and writes a .txt file in delimitted format. After the file is created on the C drive of the server I want to attach the file in a email and send it to the recepients.
I have used the built in package and can send emails...but it goes with out the attachment...
Can anyone tell me how can i attach the .txt file in the plsql procedure that sends the email.??