Sending mails using plsql program Post: 302089174

Sponsored Content

Special Forums IP Networking Sending mails using plsql program Post 302089174 by amol_mudholkar on Monday 18th of September 2006 02:39:32 AM

09-18-2006

Registered User

Sending mails using plsql program

I am trying to send an email to personal id using plsql program. I have written a code in plsql using UTL_TCP package where opens the connections and then senda a mail. But when i execute the program mails are not being sent.

I typed "mail" command on the unix box and got the below result
==========================================
From MAILER-DAEMON Mon Sep 18 07:03:41 2006
Date: Mon, 18 Sep 2006 07:03:41 +0100 (BST)
From: Mail Delivery Subsystem <MAILER-DAEMON>
Message-Id: <200609180603.k8I63fOH029965@hwnej05.>
To: <artiscat@hwnej05>
Subject: Returned mail: see transcript for details
Content-Length: 4339

This is a MIME-encapsulated message

--k8I63fOH029965.1158559421/hwnej05.

The original message was received at Mon, 18 Sep 2006 07:03:41 +0100 (BST)
from localhost [127.0.0.1]

----- The following addresses had permanent fatal errors -----
<amolm@techmahindra.com>
(reason: 550 Host unknown)

----- Transcript of session follows -----
550 5.1.2 <amolm@techmahindra.com>... Host unknown (Name server: mailhost: host
not found)

--k8I63fOH029965.1158559421/hwnej05.
Content-Type: message/delivery-status

Reporting-MTA: dns; hwnej05.
Received-From-MTA: DNS; localhost
Arrival-Date: Mon, 18 Sep 2006 07:03:41 +0100 (BST)
Final-Recipient: RFC822; amolm@techmahindra.com
Action: failed
Status: 5.1.2
Remote-MTA: DNS; mailhost
Diagnostic-Code: SMTP; 550 Host unknown
Last-Attempt-Date: Mon, 18 Sep 2006 07:03:41 +0100 (BST)

--k8I63fOH029965.1158559421/hwnej05.
Content-Type: message/rfc822

Return-Path: <artiscat@hwnej05>
Received: from hwnej05. (localhost [127.0.0.1])
by hwnej05. (8.12.10+Sun/8.12.10) with ESMTP id k8I63fOH029963
for <amolm@techmahindra.com>; Mon, 18 Sep 2006 07:03:41 +0100 (BST)
Received: (from artiscat@localhost)
by hwnej05. (8.12.10+Sun/8.12.10/Submit) id k8I63fLW029962
for amolm@techmahindra.com; Mon, 18 Sep 2006 07:03:41 +0100 (BST)
Date: Mon, 18 Sep 2006 07:03:41 +0100 (BST)
From: Artisan Application user <artiscat@hwnej05>
Message-Id: <200609180603.k8I63fLW029962@hwnej05.>
==========================================

Could you please let me know what should i do to get rid of this problem.

I just know basics of Unix. Hence finding it difficult to resolve the problem.

Thanks & Regds
Amol

amol_mudholkar

View Public Profile for amol_mudholkar

Find all posts by amol_mudholkar

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Sending Mass mails

Hi Forum, I am extremely new to unix.Can somebody please help me out with the following: I am supposed to write a script that will ftp a file which is a .csv and conatins the following: Mail-id Path of file abc@xyz.com D:\xyz\abc.htm ash@sde.com ...

2. UNIX for Advanced & Expert Users

sending mails with attachment and also some text in mail body

Hi, Can some one help me with the syntax of the mailx that should send an attachment and also some text in the message body together. When I am using the following syntax it is not sending the attachment but only the message body. unix2dos -ascii $REPORTFILE | uuencode $PCFILE | mailx -s...

3. SuSE

How to configure Suse Enterprise Linux 9.0 for sending mails to smtp server...???

Hi All, I have a system running with Suse Enterprise Linux 9.0. xyz# uname -a Linux xyz 2.4.21-291-smp #1 SMP Tue May 24 14:07:45 UTC 2005 i686 unknown I would like to configure postfix on this system for sending mails as a root user using "mail" command to smtp server (Windows System)...

4. Shell Programming and Scripting

error while sending mails through MKS

#!/bin/ksh email0="dummy@company.com" emails() { # mail Generation echo "Hi" | /mapimail -s "-(Test Mail)From Production- `date`" $email0; } emails i receive the following error IDispatch::new MSMAPI.MAPISession failed: 800401f3 at...

5. UNIX for Dummies Questions & Answers

Sending mails to various users without hard coding the email IDS

Hi Can any one help me out ? I am trying to send an autogenerated mail with an attachment to bulk of users using 'MAILX' and 'UNENCODE' . I have used it as follows X " ( cat /sastemp/body.txt; uuencode Test.xls.gz Test.xls.gz ) | mailx -s 'Testing' ' abcd@yahoo.com , efgh@gmail.com ' " ...

6. Shell Programming and Scripting

cron not sending external mails

This script is to send a email if the IP adress is active when i run this script it is working and sending emails to external users in different domains, but when this script is scheduled in a cron it is unable to send the emails #/bin/sh ifconfig -a | grep 192.168.0.1 if ; then mail -s...

7. Shell Programming and Scripting

Sending email from a unix program

Hi, I have create a unix prog file to validate data and send out an email. Below is the command used to send out email in the program. But it is not triggering the email. Please advice on this. (echo ${MESSAGE};uuencode "$FCP_OUT" "ERROR_REPORT.csv"; uuencode "$VALIDATION_RPT"...

8. Solaris

Crontab schedule sending two mails insted of one

Hi all, We have scheduled one cronjob which is supposed to show output through mails about 15 systems's current status (whether its up or down) but it send two mails one about 10 system which arrive at 5.30(actual scheduled time) and in second mail about 5 systems. We want all these...

9. Solaris

Sending Mails to the Multiple Email Address

Hi All, I am pretty new to the mail service in Sun Solaris 5.10. If anybody help me in writing a script for the multiple recipient with subject and the body would be a helpful. Kindly help... Thanks in advance. :) Warm Regards, Pramod

LEARN ABOUT DEBIAN

mlmmj-send

mlmmj-send(1)						      General Commands Manual						     mlmmj-send(1)

NAME

       mlmmj-send - send mail to a mailinglist or similar

SYNOPSIS

       mlmmj-send [-L /path/to/list | -l listctrl] -m /path/to/mail [-a] [-D] [-F] [-h] [-o] [-r] [-R] [-s] [-T] [-V]

       -a: Don't archive the mail

       -D: Don't delete the mail after it's sent

       -F: What to use as MAIL FROM:

       -h: This help

       -l: List control variable.

       -L: Full path to list directory

       -m: Full path to mail file

       -o: Address to omit from distribution (normal mail only)

       -r: Relayhost IP address (defaults to 127.0.0.1)

       -R: What to use as Reply-To: header

       -s: Subscribers file name

       -T: What to use as RCPT TO:

       -V: Print version

DESCRIPTION

       This binary is used to send all kinds of mail to mlmmj managed mailinglists, but can potentially be used standalone for sending mails.

       The only option that is not self explanatory is the -l list control option:

	      '1' means 'send a single mail'

	      This is used together with -F and -T to send one mail to one recipient.

	      '2' means 'mail to moderators'

	      Used for sending mails to the moderators of a list.

	      '3' means 'resend failed list mail'

	      '4' means 'send to file with recipients'

	      '5' means 'bounceprobe'

	      '6' means 'single listmail to single recipient'

BUGS

       This  manual page is very scarce documentation of the mlmmj-send binary. The reason for this is that it's really not supposed to be used by
       any human, but only supposed to be invoked from other mlmmj binaries. So in case more documentation is needed, please read the source.

AUTHORS

       This manual page was written by the following persons:

       Soren Boll Overgaard <boll@debian.org> (based on html2man output)

       Mads Martin Jorgensen <mmj@mmj.dk>

mlmmj-send							   January 2010 						     mlmmj-send(1)