Issue with utl_mail
Oracle 11.2.0.4 SE-One, 64-bit
Oracle Linux 5
Given this bit of code:
<snip>
v_msg varchar2(32000);
<snip>
-- -------------------------------------------------------------------------
-- Email the results
-- -------------------------------------------------------------------------
if v_usrcnt > 0 then
-- -- DEBUG CODE -
dbms_output.put_line('Sending Mail');
dbms_output.put_line('Count: '||
to_char(v_usrcnt)||
'. Length: '||
to_char(length(v_msg)));
-- -- END DEBUG CODE -
sys.utl_mail.send (sender => v_sender,
recipients => v_recipients,
subject => v_subject,
message => v_msg
);
-- -- DEBUG CODE -
dbms_output.put_line('Sent Mail');
-- -- END DEBUG CODE -
end if;
I am getting this output:
0