Unable To Run Certain PLSQL Procedures After Upgrading To An 11g database.
Last updated on NOVEMBER 04, 2016
Applies to:Oracle HTTP Server - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Unable to run plsql procedure on 11g database when using mod_plsql.
error message seen:
ms>DMS Logging: Unable to establish SQL error code for error: Illegal procedure name, has an empty part
ms>/pls/pla_tt/mainplus.main1 HTTP-400 Illegal procedure name, has an empty part
The customer upgraded their environment, including 10.1.2 ---> 11g Webtier and then moving
from 10g to 11g database (126.96.36.199 in their case)
The key is the upgrade of the database, as the procedure still ran when using an 11g OHS instance and the older 10g database.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms