MOD_PLSQL FAILED WITH "HTTP-500 FAILED TO BIND TARGET PROCEDURE ORA-01036" (Doc ID 1991501.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

When executing mod_plsql application, it fails with "HTTP-500 Internal Server Error"
and ohs1.log output shows "HTTP-500 Failed to bind target procedure ORA-01036" message.

The ohs1.log shows:

 

Changes

This issue is depended on data type owa.vc_arr when parameter name is >= 30 bytes,
and sending date size is >= 1500 bytes,and multiple data is sent.

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