Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using htp.p in PL/SQL routines

Andre OlivierMar 12 2014 — edited Mar 19 2014

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?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2014
Added on Mar 12 2014
14 comments
32,980 views