Error ORA-00932 Using UTL_DBWS package Consuming a Web Service in RDBMS 10.2/11.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***
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms