Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 12-28-2012, 02:23 PM   #1
LQ Newbie
Registered: Nov 2012
Posts: 5

Rep: Reputation: Disabled
Linux Script - UTL_MAIL - SQL PLUS

I can get UTL_MAIL to work in sqlplus, but can not get it to
work in a script. I don't know if anyone on the Linux forum can help, but if you can, I would much appreciate it. Thanks in advance! The following is the script:

/home/oracle/product/11g/bin/sqlplus "/ as sysdba" << EOF
execute immediate 'alter session set smtp_out_server = ''''';
utl_mail.send(sender => '',
recipients => '',
subject => 'Test Email from script 5',
message => 'Hello World',
mime_type => 'text; charset=us-ascii');
Old 01-07-2013, 08:54 PM   #2
Senior Member
Registered: Aug 2009
Posts: 3,790

Rep: Reputation: 653Reputation: 653Reputation: 653Reputation: 653Reputation: 653Reputation: 653
Do you get an error message at all ?


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
running sql script under sqlite3 miamagoo Linux - Newbie 1 06-16-2010 10:23 AM
sql script to find out the userid Prasun1 Linux - General 5 07-01-2005 10:54 AM
Shell script to run pl/sql script. colly Linux - General 1 09-09-2004 07:49 AM
Speeding up the script, or the SQL Query? knickers Programming 1 04-13-2004 12:57 PM
How do I run an .sql script? vous Programming 6 08-07-2003 11:11 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 09:48 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration