Call PL/SQL procedure from URL in Oracle APEX

Here are few simple steps to follow before calling procedure from browser-

• Provide access on your procedure to "ANONYMOUS" user by executing-

grant execute on SCHEMA_NAME.PROCEDURE_NAME to ANONYMOUS;

• modifying the APEX function wwv_flow_epg_include_mod_local by  executing below code

CREATE OR REPLACE function APEX_050100.wwv_flow_epg_include_mod_local(

    procedure_name in varchar2)

return boolean

is

begin     

    if upper(procedure_name) in (

          'SCHEMA_NAME.PROCEDURE_NAME') then

        return TRUE;

    else

        return FALSE;

    end if;

end wwv_flow_epg_include_mod_local;

/

Apex schema name will vary based on version like for APEX_050100,APEX_050000,APEX_040100... etc.

Note: login with SYSTEM account to execute above code.