Datatype Not Supported With XDB Webservices (Doc ID 2197142.1)

Last updated on NOVEMBER 09, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 12.1.0.1 [Release 11.1 to 12.1]
Information in this document applies to any platform.

Symptoms

Got the below in the browser while accessing the package using xdb webservices

URL TO ACCESS PACKAGE

http://hostname:port/orawsv/SCHEMA/PACKAGE_NAME?wsdl

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<soap:Fault>
<faultcode>soap:Client</faultcode>
<faultstring>Error processing input</faultstring>
<detail>
<OracleErrors xmlns="http://xmlns.oracle.com/orawsv/faults">Incorrect Input Doc/URL</OracleErrors>
</detail>
</soap:Fault>
</soap:Body>
</soap:Envelope>

 

Package

create or replace package Package_Name
AS

TYPE type_eopt_refcur IS REF CURSOR;         
FUNCTION get_rebate_status(p_acct_number IN ACCOUNT.ACCOUNT_NUMBER%TYPE)
RETURN type_eopt_refcur;
END eoptrebate;

 

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