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 MARCH 14, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
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
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 |