Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Open Source > Perl
|
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Perl section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 1st, 2011, 01:16 PM
Registered User
 
Join Date: Mar 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Invoking or calling a sqlldr control file and using e-mail functionality in perl

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
 
Old March 2nd, 2011, 02:16 AM
Authorized User
 
Join Date: Aug 2009
Posts: 23
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Quote:
Originally Posted by msrblr View Post
2) Also can anyone please help me as to how to use the E-mail functionality in my perl script.
Try MIME::Lite module from CPAN.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail functionality from localhost to server ctatvasoft Beginning PHP 1 December 13th, 2009 09:56 PM
Invoking a batch file from servlet vinayreddy Servlets 3 October 24th, 2008 02:12 AM
Invoking Help File MichaelRReed1939 VB How-To 1 October 26th, 2006 10:37 AM
Calling procedure of User Control from aspx file vskumar VB.NET 1 February 15th, 2005 11:17 AM
Invoking E-mail Client When Button Is Clicked Ben Horne Flash (all versions) 4 March 25th, 2004 10:06 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.