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

Do you get an error message at all ?