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

mon::snmp

Mon::SNMP(3pm)						User Contributed Perl Documentation					    Mon::SNMP(3pm)

NAME

       Mon::SNMP - decode SNMP trap

SYNOPSIS

	   use Mon::SNMP;

	   $trap = new Mon::SNMP;

	   $trap->buffer($snmptrap);

	   %traphash = $trap->decode;

	   $error = $trap->error;

DESCRIPTION

       Mon::SNMP provides methods to decode SNMP trap PDUs. It is based on Graham Barr's Convert::BER module, and its purpose is to provide SNMP
       trap handling to "mon".

       It is not complete, so don't bother trying to use it unless you are ready to debug and write some code.

METHODS

       new creates a new Mon::SNMP object.

       buffer ( buffer )
	   Assigns a raw SNMP trap message to the object.

       decode
	   Decodes a SNMP trap message, and returns a hash of the variable assignments for the SNMP header and trap protocol data unit of the
	   associated message. The hash consists of the following members:

		   version	   =>	   SNMP version(1)
		   community	   =>	   community string
		   ent_OID	   =>	   enterprise OID of originating agent
		   agentaddr	   =>	   IP address of originating agent
		   generic_trap    =>	   /COLDSTART|WARMSTART|LINKDOWN|LINKUP|AUTHFAIL|EGPNEIGHBORLOSS|ENTERPRISESPECIFIC/
		   specific_trap   =>	   specific trap type (integer)
		   timeticks	   =>	   timeticks (integer)
		   varbindlist	   =>	   { oid1 => value, oid2 => value, ... }

ERRORS

       All methods return a hash with no elements upon errors which they detect, and the detail of the error is available from the

EXAMPLES

	   use Mon::SNMP;

	   $trap = new Mon::SNMP;

	   $trap->buffer($snmptrap);

	   %traphash = $trap->decode;

	   foreach $oid (keys $traphash{"varbindlist"}) {
	       $val = $traphash{"varbindlist"}{$oid};
	       print "oid($oid) = val($val)
";
	   }

ENVIRONMENT

       None.

SEE ALSO

       Graham Barr's Convert::BER module.

NOTES

CAVEATS

       Mon::SNMP depends upon Convert::BER to do the real work.

perl v5.14.2							    2012-04-27							    Mon::SNMP(3pm)