Here is our environment
SQL Developer 3.2.20.09
APEX Listener 126.96.36.1998.17.04
1. procedure.preProcess and procedure.postProcess work only in the defaults.xml file. So, if you need different procedures for different database connections or if you want to use it for one database connection but not the other, this will not work. We configured Database Access Descriptors (DADs) using dbms_epg to get around this issue.
2. You cannot query any CGI environment variables in procedure.preProcess using owa_util.get_cgi_environment; for example owa_util.get_cgi_environment('REMOTE_USER'). This will raise a "500 - Internal Server Error" in the browser and "Executing procedure failed for before_proc" in the glassfish server.log. For this issue, we moved all the CGI environment variable queries from procedure.preProcess to procedure.postProcess.
Are these issues that we will need to work around or will it be addressed in the final release? I would appreciate if someone from Oracle would also comment.