Error ORA-00932 Using UTL_DBWS package Consuming a Web Service in RDBMS 10.2/11.1 (Doc ID 785957.1)

Last updated on MARCH 20, 2017

Applies to:

Web Services - Version 10.1.3.0.0 to 10.1.3.4.0
Information in this document applies to any platform.
***Checked for relevance on 30-OCT-2013***


Symptoms

You want to consume a web service from the data server using the PL/SQL UTL_DBWS package.
PL/SQL will call the webservice and pass a BLOB/CLOB ( a PDF document for example) to the web service in synchronous mode. The data server is Oracle version 10g R2 (10.2.0.x). 

When the response exceeds 64 kB following error will occur:

ORA-00932: inconsistent datatypes: expected a return value that is an instance of a user defined. Java class convertible to an Oracle type got an object that could not be converted

 

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