CREATE LUA SCRIPT "SEND_MAIL" ()
RETURNS ROWCOUNT AS
smtp = require('socket.smtp')
sender = 'service@exasol.com'
receivers = { 'captain.exasol@exasol.com' } message_text = 'hello world'
mesgt = {
headers = {
to = 'Captain EXASOL <captain.exasol@exasol.com>',
from = 'EXASOL Service <service@exasol.com>',
subject = 'The mail you requested'
},
body = message_text
}
res, err = smtp.send{
from = sender,
rcpt = receivers,
source = smtp.message(mesgt),
server = 'mail.exasol.com'
}
if err then
error(err)
end
/