LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


Reply
  Search this Thread
Old 12-28-2012, 02:23 PM   #1
sharon@msd321.com
LQ Newbie
 
Registered: Nov 2012
Posts: 5

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


Hello,
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
begin
execute immediate 'alter session set smtp_out_server = ''10.0.0.45''';
utl_mail.send(sender => 'Computer_Support@msd321.com',
recipients => 'sharon@msd321.com',
subject => 'Test Email from script 5',
message => 'Hello World',
mime_type => 'text; charset=us-ascii');
end;
exit;
EOF
 
Old 01-07-2013, 08:54 PM   #2
kbp
Senior Member
 
Registered: Aug 2009
Posts: 3,790

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


Reply


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


All times are GMT -5. The time now is 06:10 AM.

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