Hi,

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
Thanks

Try MIME::Lite module from CPAN.