APEXblog.nl - Tips and Tricks

About This Blog:
I (Richard Weug) started this blog primary for myself to save all kinds of Apex tips and tricks in one place. To use it as a place to write down how I used some coding in my own projects, but also to copy and paste all kinds of articles I find on the Internet. (So I never have to wonder on what website did I read about??? When I see something interesting I collect the content so I have my own archive/knowlegde base.

View my profile on LinkedIn

 

Tips & Tricks

Print
13
Feb

Allow a procedure to be executed from Apex

Written by Richard Weug. Posted in Tips and Tricks

Why won't the procedure execute? This is because Apex won't let you directly execute procedures from within Apex. You have to place these procedures in a special function, so these procedures are allowed to be executed.

Which function to alter?
Connect to the database as SYS
Open the (in my case)  APEX_04000 schema
Load and edit the function APEX_040000.wwv_flow_epg_include_mod_local

 

CREATE OR REPLACE function APEX_040000.wwv_flow_epg_include_mod_local(
    procedure_name in varchar2)
return boolean
is
begin
    --return false; -- remove this statement when you modify this function
    --
    -- Administrator note: the procedure_name input parameter may be in the format:
    --
    --    procedure
    --    schema.procedure
    --    package.procedure
    --    schema.package.procedure
    --
    -- If the expected input parameter is a procedure name only, the IN list code shown below
    -- can be modified to itemize the expected procedure names. Otherwise you must parse the
    -- procedure_name parameter and replace the simple code below with code that will evaluate
    -- all of the cases listed above.
    --
    if upper(procedure_name) in (
             'DOWNLOAD_MY_FILE'
           , 'MLG_PCK.SENT_MAIL'
           , 'CLIEOP.BEPAAL_DEELBETALINGEN'
           ) then
        return TRUE;
    else
        return FALSE;
    end if;

end wwv_flow_epg_include_mod_local;
/