02-02-2006
How to send Mail with Attachement
Hi
Can somebody help me in wirting shell script in the following way.Desperately i have poseted this..
1.How can I connect to Oracle(Sqlplus) from UNIX.
2.After connecting to it I have to execute an oracle proceudure..
3.Execution of the procedure will give some set of rows..
4.The set of rows have to be 'Spool' to a seperate file and that file has to be sent to particular user as attachement.
Regards
Gopinath
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Dear All:
I want to send a message to a list of people with a subject and an attachement, currently I am using the following command into a shell script:
uuencode $FILENAME.gz $FILENAME.gz | mail john.kennedy@mycompany.com m.m@mycompany.com
With this command I can send the message for a... (1 Reply)
Discussion started by: josecollantes
1 Replies
2. UNIX for Dummies Questions & Answers
I wanted to try sending a mail with an attachement at command prompt in unix. Some one please advise that how we can do it ?
Thanks, :) (2 Replies)
Discussion started by: gaddeg
2 Replies
3. UNIX for Dummies Questions & Answers
Hi all,
I am a newbie to unix.
I need to send an email with an attachment in unix to some id like abc@some_company.com
Code i have used is
------------Code---------------------------
#!/bin/ksh
set -x
#set -n
#cript: unix_mail_withattachments.ksh
# Aurthor: Ravin Maharaj
#... (1 Reply)
Discussion started by: samuelc
1 Replies
4. Shell Programming and Scripting
Hi all,
i am working with CSH, i want to know that
how to send a mail in UNIX shell script (CSH) with attachment as well as message body.
i know that how to send a mail with attachment and message body. but i want know both things in a single mail
Suggession would be appreciate.
... (1 Reply)
Discussion started by: psiva_arul
1 Replies
5. Shell Programming and Scripting
Hi All,
I have general query that ...in my script i used uuencode
option like below.
cd /location
(cat test.txt
uuencode test.csv test.csv ) | mail -s "test mail" "mail_id"
but whenever i run the above command its giving error like below
./testscript.sh: uuencode not found:
... (1 Reply)
Discussion started by: Shahul
1 Replies
6. UNIX for Advanced & Expert Users
I want to read attachements sent to unix mail id and save the attachement in folder.
I may receive the mails from different mail clients(outlook, lotus ..etc).
Attachements are in CSV(comma saperate) format.
Let me know the shell script code for this.
Regards,
Venkat (1 Reply)
Discussion started by: svenkatareddy
1 Replies
7. Shell Programming and Scripting
Can't attach text files to 'mail' command. I dont have mutt or mailx to use on my server. so i have to use mail command
any help would be great.
Regards,
Kiran (1 Reply)
Discussion started by: dddkiran
1 Replies
8. Shell Programming and Scripting
Hi ,
I am using the below code to send mail through a script which run as a cron job.
msgdate=`date +"%a, %e %Y %T %z"`
daemail=$(cat <<!
From: $from
To: $emailtarget
Subject: $subject
Mime-Version: 1.0
Content-Type: multipart/mixed;
Content-Disposition: inline
$priority
$CONTENT
!)... (2 Replies)
Discussion started by: ahamed
2 Replies
9. Solaris
Hello,
I am able to attache the file in UNIX/LINUX script using following code.
MAILFORMAT="Please do not replay this mail.This mail is auto generated."
echo -e $MAILFORMAT | mailx -r autoreplay@gmail.com -a filename -s "status" xyz@gmail.com
But same I am not able attache... (6 Replies)
Discussion started by: nes
6 Replies
LEARN ABOUT DEBIAN
dbix::contextualfetch
DBIx::ContextualFetch(3pm) User Contributed Perl Documentation DBIx::ContextualFetch(3pm)
NAME
DBIx::ContextualFetch - Add contextual fetches to DBI
SYNOPSIS
my $dbh = DBI->connect(...., { RootClass => "DBIx::ContextualFetch" });
# Modified statement handle methods.
my $rv = $sth->execute;
my $rv = $sth->execute(@bind_values);
my $rv = $sth->execute(@bind_values, @bind_cols);
# In addition to the normal DBI sth methods...
my $row_ref = $sth->fetch;
my @row = $sth->fetch;
my $row_ref = $sth->fetch_hash;
my %row = $sth->fetch_hash;
my $rows_ref = $sth->fetchall;
my @rows = $sth->fetchall;
my $rows_ref = $sth->fetchall_hash;
my @tbl = $sth->fetchall_hash;
DESCRIPTION
It always struck me odd that DBI didn't take much advantage of Perl's context sensitivity. DBIx::ContextualFetch redefines some of the
various fetch methods to fix this oversight. It also adds a few new methods for convenience (though not necessarily efficiency).
SET-UP
my $dbh = DBIx::ContextualFetch->connect(@info);
my $dbh = DBI->connect(@info, { RootClass => "DBIx::ContextualFetch" });
To use this method, you can either make sure that everywhere you normall call DBI->connect() you either call it on DBIx::ContextualFetch,
or that you pass this as your RootClass. After this DBI will Do The Right Thing and pass all its calls through us.
EXTENSIONS
execute
$rv = $sth->execute;
$rv = $sth->execute(@bind_values);
$rv = $sth->execute(@bind_values, @bind_cols);
execute() is enhanced slightly:
If called with no arguments, or with a simple list, execute() operates normally. When when called with two array references, it performs
the functions of bind_param, execute and bind_columns similar to the following:
$sth->execute(@bind_values);
$sth->bind_columns(undef, @bind_cols);
In addition, execute will accept tainted @bind_values. I can't think of what a malicious user could do with a tainted bind value (in the
general case. Your application may vary.)
Thus a typical idiom would be:
$sth->execute([$this, $that], [($foo, $bar)]);
Of course, this method provides no way of passing bind attributes through to bind_param or bind_columns. If that is necessary, then you
must perform the bind_param, execute, bind_col sequence yourself.
fetch
$row_ref = $sth->fetch;
@row = $sth->fetch;
A context sensitive version of fetch(). When in scalar context, it will act as fetchrow_arrayref. In list context it will use
fetchrow_array.
fetch_hash
$row_ref = $sth->fetch_hash;
%row = $sth->fetch_hash;
A modification on fetchrow_hashref. When in scalar context, it acts just as fetchrow_hashref() does. In list context it returns the
complete hash.
fetchall
$rows_ref = $sth->fetchall;
@rows = $sth->fetchall;
A modification on fetchall_arrayref. In scalar context it acts as fetchall_arrayref. In list it returns an array of references to rows
fetched.
fetchall_hash
$rows_ref = $sth->fetchall_hash;
@rows = $sth->fetchall_hash;
A mating of fetchall_arrayref() with fetchrow_hashref(). It gets all rows from the hash, each as hash references. In scalar context it
returns a reference to an array of hash references. In list context it returns a list of hash references.
ORIGINAL AUTHOR
Michael G Schwern as part of Ima::DBI
CURRENT MAINTAINER
Tony Bowden <tony@tmtm.com>
LICENSE
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
DBI. Ima::DBI. Class::DBI.
perl v5.10.0 2005-09-27 DBIx::ContextualFetch(3pm)