error in UTL_SMTP.rcpt command
Hi,
I am using UTL_SMTP.rcpt commnd to send mail to multiple user but its getting error when v_email_id_1 string length exceeds 500 .
UTL_SMTP.rcpt(v_l_mail_conn, v_email_id_1);
v_l_mail_conn := UTL_SMTP.connection;
v_email_id_1:= is a varchar2 field which contain list of people to whom we have to send mail.
Please suggest some other option or root cause of the error ?
Thanks in advance.