This discussion is archived
1 2 3 Previous Next 33 Replies Latest reply: Feb 3, 2013 2:13 AM by Gor_Mahia Go to original post RSS
  • 30. Re: running jquery code after button submits successfully.
    Mahmoud_Rabie Journeyer
    Currently Being Moderated
    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
    Gor, to have a good reputation in this forums, you have to close thread when it is answered and try to be clear as much as you can to help you efficiently
  • 31. Re: running jquery code after button submits successfully.
    Gor_Mahia Explorer
    Currently Being Moderated
    Hey Jari,
    I marked the other question correct and closed but would you pls take a look why i cant send email attachment now, modified the process as below,
    declare
    l_id number;
    
    begin
    l_id := APEX_MAIL.SEND(
     p_to=> 'peterson1@gmail.com',
     p_from =>'peterson1@gmail.com',
    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;
    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?

    wspace=proj2010
    userid/pwd=demo123/demo123
    app=760 page999

    regards.
  • 32. Re: running jquery code after button submits successfully.
    jariola Guru
    Currently Being Moderated
    Hi,

    Your example works ok for me.
    I did test to send my email and I get attachments.

    Regards,
    Jari
    -----
    My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0
    Twitter: http://www.twitter.com/jariolai
  • 33. Re: running jquery code after button submits successfully.
    Gor_Mahia Explorer
    Currently Being Moderated
    Jari
    great, the question closed finally have a good weekend.

    regards
1 2 3 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points