Hi,
I am trying to create and send URL from apex.oracle.com but seems there is some problem in the created URL,
SELECT apex_mail.get_instance_url || APEX_UTIL.PREPARE_URL(p_url => 'f?p=' || v('APP_ID') || ':13:'|| v('APP_PAGE_ID') ||'::NO::P13_ID:1') into v_PAGE_URL FROM DUAL;
apex_mail.send (
p_to => 'sikandar.awan@gmail.com',
p_template_static_id => 'JOB_REQUISITION',
p_placeholders => '{' ||
' "ORDER_NUMBER":' || apex_json.stringify( 'l_business_ref' ) ||
' ,"CUSTOMER_NAME":' || apex_json.stringify( 'some_value' ) ||
' ,"MY_APPLICATION_LINK":' || apex_json.stringify(v_PAGE_URL) ||
' ,"ORDER_URL":' || apex_json.stringify( 'some_value' ) ||
'}' );
No idea why pls/apex//pls/apex is duplicated in the output URL? APEX version is 21.2 and it is apex.oracle.com