My Oracle Support Banner

Plsql Procedures Fail with Error ORA-06502/ORA-06512 When htp.init Is Included (Doc ID 604999.1)

Last updated on JANUARY 03, 2025

Applies to:

Oracle HTTP Server - Version 10.1.2.0.0 to 10.1.3.4 [Release AS10gR2 to AS10gR3]
Information in this document applies to any platform.
This problem can occur on any platform.
This applies to OHS 10g delivered with the mod_plsql and the PL/SQL Toolkit (OWA) packages in the Database.
This is fixed in 10.1.2.0.7 and higher, where the OWA packages may be separately installed with the Oracle Database.



Symptoms

With plsql toolkit version 10.1.2.0.5 and 10.1.2.0.6, the following procedure fails with htp.init included:



The error only happens when htp.init is added to the procedure.
Executing htp.init alone is error free.

.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.