Unable To Run Certain PLSQL Procedures After Upgrading To An 11g database. (Doc ID 1407367.1)

Last updated on NOVEMBER 04, 2016

Applies to:

Oracle HTTP Server - Version 11.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

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

Changes

The customer upgraded their environment, including 10.1.2 ---> 11g Webtier and then moving
from 10g to 11g database (11.2.0.1 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.

Cause

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