Problems to SEND MAIL using WWV_FLOW_MAIL.SEND - APEX_MAIL
530291Aug 23 2010 — edited Aug 28 2010I tried send mail using the code below
DECLARE
l_body CLOB:= EMPTY_CLOB;
l_body_html CLOB:= EMPTY_CLOB;
BEGIN
wwv_flow_api.set_security_group_id;
l_body :='<html>
+<head>+
+<style type="text/css">+
+body{font-family: Arial, Helvetica, sans-serif;+
+font-size:10pt;+
+margin:30px;+
+background-color:#ffffff;}+
+span.sig{font-style:italic;+
font-weight:bold;
color:#811919;}
+</style>+
+</head>+
+<body>+
+</html>';+
l_body_html := '<html>
+<head>+
+<style type="text/css">+
+body{font-family: Arial, Helvetica, sans-serif;+
+font-size:10pt;+
+margin:30px;+
+background-color:#ffffff;}+
+span.sig{font-style:italic;+
font-weight:bold;
color:#811919;}
+</style>+
+</head>+
+<body>+
+</html>';+
wwv_flow_mail.send('jserrot@yahoo.com.br','sle141012@terra.com.br',nvl(l_body,'Texto com erro'),nvl(l_body_html,'erro2'),'K','sle141012@terra.com.br',
+'sle141012@terra.com.br','sle141012@terra.com.br');+
wwv_flow_mail.push_queue;
END;
+/+
This code return the message:
Mail To From Subject CC BCC Created On Created By Error Created
CHECK$01 jserrot@yahoo.com.br sle141012@terra.com.br K sle141012@terra.com.br sle141012@terra.com.br 08/23/2010 03:05:00 PM SYS
ORA-06502: PL/SQL: erro: erro de conversão de caractere em número numérico ou de valor
Follow my mail settings
SMTP Host Address : POP.SLE.TERRA.COM.BR
SMTP Host Port 110
Administration Email Address SLE141012@TERRA.COM.BR
Notification Email Address SLE141012@TERRA.COM.BR
what´s wrong ?