I'm trying to implement a mail procedure with UTL_SMTP that will allow for BCCs (blind carbon copy recipients). My procedures are all wrapped up in a package that works quite well for everything else we're needing right now, but we didn't have BCC support implemented so we're trying to add it. Everything compiles fine and the procedures run fine with the exception that the BCC doesn't get a copy of the message.
We added this call to procedure to add the BCC header, where p_recip_bccs is a parameter of the procedure call and conn is the smtp connection:
-- Set "CC" MIME header
write_mime_header(conn, 'Bcc', p_recip_bccs);
and write_mime_header looks like this, to give the header the correct format:
utl_smtp.write_data(conn, name || ': ' || value || utl_tcp.CRLF);
I've watched this procedure repeatedly through the debugger and all the values seem to be properly formatted but the message never shows up in the BCCs mailbox.
Anyone have any experience with this and have an idea what might be going on? I'd be glad to post more of the code if you think it might be necessary. Thanks.
Earl
Message was edited by:
Earl