Calling a Java Stored Procedure from PL/SQL Fails with Ora-932 Inconsistent Datatypes in 11.2.0.2 (Doc ID 1384343.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 13-May-2013***

Symptoms

After upgrade to Oracle version 11.2.0.2, a Java Stored Procedure called from PL/SQL fails with ORA-00932: inconsistent datatypes: expected a Java type at argument position 3 to which some Oracle value can be converted got something else.

The code worked in 11.2.0.1 and earlier versions.

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