We have an Apex application, originally written in Apex 4.0 on a Oracle 10g XE database. Within this application, use is made of htp.p calls at various points (eg. to generate a report at the end of a process).
Following an upgrade to Oracle 11g XE and Apex 4.2.4, the htp.p calls do not work. We do not get any error messages, either on screen or in the logs, they simply just do nothing.
Our initial assumption was that this had something to do with the fine grained security introduced in 11g, and we attempted to fix the situation by adding ACL entries. Either we have not arrived at the correct ACL setting, or the problem isn't related to security. We are now at the point of rewriting various PL/SQL functions to remove the htp.p constructs, and use other mechanisms as a workaround. This is obviously a time consuming exercise, and there is an element of risk involved, and all the while the production system is not working correctly.
Does anyone have any suggestions around this?