Error ORA-00932 Using UTL_DBWS package Consuming a Web Service in RDBMS 10.2/11.1
(Doc ID 785957.1)
Last updated on AUGUST 25, 2021
Applies to:Web Services - Version 10.1.3.0.0 to 10.1.3.4.0
Information in this document applies to any platform.
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
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