Importing data from PL/SQL then sending it through mail,HELP ME!

10 More Discussions You Might Find Interesting

1. Windows & DOS: Issues & Discussions

Help importing SQL DB using phpmyadmin

Hi, When I try to import the database, getting error message. No data was received to import. Either no file name was submitted or the file size exceeded the maximum size permitted by your PHP configuration. I am doing this on Windows server, I updated php.ini file and stop and...

2. Red Hat

Problems sending mail: Difference between Mail and Mailx?

Whats the difference between mail and mailx? I'm trying to troubleshoot a problem where I can send mail from server A with this `echo $MESSAGE | mail -s "$SUBJECT" -r $FROM $RECIPIENTS` command but executing the same command from server B throws me this error (Both servers are RHEL) ...

3. UNIX and Linux Applications

Importing data's from cadence to MATLAB

hello, debashish here. i am working with 6 bit flash ADC design. So for calculation of INL and DNL ,i have to import data from cadence to MATLAB . Can anybody help me out:confused:

4. Shell Programming and Scripting

Executing SQL Query and sending a mail

Hi all, My reqirenet goes like this. Need to execute one select statement within the script and send a mail to the users with the number of records fecthed from the query. Please help.. Thanks.

5. UNIX for Dummies Questions & Answers

Data Importing using shell script

Hi All, I have a .csv file pipe delimter.., I am using excel data import option for importing the data from a pipe delimter file to xls...I want to make this happen using shell script. Please let me know how can I do this using shell script. Regards, Deepti

6. Shell Programming and Scripting

Stop sending mail after certain number of mail

Hi guys... I am busy writing a script to notify me via an mail if my application is down. I have done that. Now I want this script to stop sending mails after five mails were sent but the script should keep on checking the application. When the application is up again that count should be...

7. Shell Programming and Scripting

sending mail using Mailx with data from oracle table

Hi, i need to send emails to the mail ids i receive using the sql query . SELECT L.ALARM_DEF,L.CRITERIA,L.DISTANCE_METRE,L.EMAIL,L.LAC_ID,L.LAST_CHECK,L.RANGE, L.RESOURCE_MSISDN,LM.ADDRESS,LM.NAME FROM LANDMARK_ALARM_CONF l, LANDMARK lm WHERE L.LANDMARK_ID=LM.LANDMARK_ID AND...

8. UNIX for Advanced & Expert Users

Issues while sending a mail having records fetched from SQL -all in UNIX

hi-I want to write a UNIX Script which will fetch records from Oracle database.I want to store these records in a file under fields like email address,name and the transaction_id and then fetch these records from the file and send the email to individual users with their transaction ID details.

9. OS X (Apple)

importing Entourage messages to Apple Mail

I have large number of messages under entourage 2008 in my INBOX ( over 2000) and the same number in SENT box. importing mailboxes under File/import didnt work. draggin the mailbox from entourage to desktop then to mail pane didnt work either. any other way that does it ?

10. UNIX for Dummies Questions & Answers

sending a mail to a mail client

Hi everyone! I'm trying to create a database monitoring script that reads an alert file and sends an error message if it can 'grep' a particular string. Is there a way to send this message to a mail client using SMTP? Even better, is there any place on this site that has these kinds of...

LEARN ABOUT DEBIAN

ledgersmb::mailer

LedgerSMB::Mailer(3pm)					User Contributed Perl Documentation				    LedgerSMB::Mailer(3pm)

NAME

       LedgerSMB::Mailer - Mail output for LedgerSMB

SYNOPSIS

COPYRIGHT

	#====================================================================
	# LedgerSMB
	# Small Medium Business Accounting software
	# http://www.ledgersmb.org/
	#
	# Copyright (C) 2006
	# This work contains copyrighted information from a number of sources
	# all used with permission.
	#
	# This file contains source code included with or based on SQL-Ledger
	# which # is Copyright Dieter Simader and DWS Systems Inc. 2000-2005
	# and licensed under the GNU General Public License version 2 or, at
	# your option, any later version.  For a full list including contact
	# information of contributors, maintainers, and copyright holders,
	# see the CONTRIBUTORS file.
	#
	# Original Copyright Notice from SQL-Ledger 2.6.17 (before the fork):
	# Copyright (C) 2002
	#
	#  Author: DWS Systems Inc.
	#	Web: http://www.sql-ledger.org
	#
	#  Contributors:
	#
	# Original Author and copyright holder:
	# Dieter Simader dsmimader@sql-ledger.com
	#====================================================================

METHODS

   LedgerSMB::Mailer->new(...)
       Create a new Mailer object.  If any arguments are passed in, a message that uses them will be automatically prepared but not sent.

   $mail->prepare_message(to => $to, from => $from, ...)
       Prepares and encodes base message for sending or adding attachments.

       Arguments

       to, from, cc, bcc
	   Address fields for the email.

       subject
	   The subject for the email.

       message
	   The message body for the email.

       contenttype
	   The conttent type for the body of the message, not for any attachments.

       notify
	   Sets the Disposition-Notification-To header (read receipt request) for the message.	This header will only be added if a from address
	   is set.

   $mail->attach(data => $data, file => $file, filename => $name, strip => $strip)
       Add an attachment to the prepared message.  If $data is specified, use the value of that variable as the attachment value, otherwise attach
       the file given by $file.  If both a file and data are given, the data is attached.  filename must be given and is used to name the
       attachment.

       $strip is an optional string to remove from the filename send with the attachment.

   $mail->send
       Sends a prepared message using the method configured in ledgersmb.conf.

perl v5.14.2							    2012-03-26						    LedgerSMB::Mailer(3pm)

Shell Programming and Scripting