I think question you now asking is totally different than original one. In these cases it might be best create new thread and mark old thread as answered. This helps also other find information from these forums.That's right
i really need your help on this, i use Apex 4.1.1 but i put here(4.2) the same email code in the process iam using. Kindly tell me why the attachment now doesnt work?
declare l_id number; begin l_id := APEX_MAIL.SEND( p_to=> 'email@example.com', p_from =>'firstname.lastname@example.org', p_subj =>'some test', p_body=>'Your mail' ); for i in(select id,blob_content, filename, mime_type from apex_application_files where rownum <= 2 order by id desc) loop APEX_MAIL.ADD_ATTACHMENT( p_mail_id => l_id, p_attachment => i.blob_content, p_filename => i.filename, p_mime_type => i.mime_type); end loop; commit; insert into tab1(val1, val2) values(:p999_val1, :p999_val2); -- -- also some code to process uploaded file here. -- :P999_PROMT := 'New record created succesfully'; exception when others then null; end;