LinuxQuestions.org
Share your knowledge at the LQ Wiki.
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, 01: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, 07: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 09:23 AM
sql script to find out the userid Prasun1 Linux - General 5 07-01-2005 09:54 AM
Shell script to run pl/sql script. colly Linux - General 1 09-09-2004 06:49 AM
Speeding up the script, or the SQL Query? knickers Programming 1 04-13-2004 11:57 AM
How do I run an .sql script? vous Programming 6 08-07-2003 10:11 AM


All times are GMT -5. The time now is 09:57 PM.

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