Invoking or calling a sqlldr control file and using e-mail functionality in perl
I have written a perl script which loads the data into the oracle table.
1) I have written control file, and i want to know as to how to use SQLLDR control file in my existing perl script.
2) Also can anyone please help me as to how to use the E-mail functionality in my perl script.
After the data is loaded into the table, the user should be notified by e-mail and the things that he should be notified is:
(a) Was it a success or Failure.
(b) Total No. of records loaded. (If success).
(c) Send the log file as attachments in the e-mail.
Appreciate any help