I hope someone can shed light on this issue..
I tried to allow executing procedures using the configuration property in APEX Listener. For example, I want to call the procedure: MYSCHEMA.MYPROCEDURE
The setting would be like this, please correct me if I'm wrong:
... <entry key="security.inclusionList">wwv_flow*, p, n, cust*, apex*, f, MYSCHEMA.MYPROCEDURE</entry> ...
However, setting the property does not take effect.
I read in some other posts that the user APEX_PUBLIC_USER must be granted to execute the procedure:
GRANT EXECUTE ON MYSCHEMA.MYPROCEDURE TO APEX_PUBLIC_USER;
Indeed, it works!
But then I do not need setting the configuration property as it works without it.
What is the official way to do it then?