My Oracle Support Banner

Rest Services Are Not Working When There Is A Reference Cursor As Out Parameter (Doc ID 2510383.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle E-Business Suite Integrated SOA Gateway - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Rest services are not working which has REF Cursor used

When REST services are deployed, if the service has REF CURSOR as parameter,

its not returning the values, but if we have OUT parameters defined with fixed

parameters, services are returning the values

 

(or)

Invoke a web service (which has ref cursor as return type) from a rest client the below error is noticed

oracle.apps.fnd.soa.rt.rest.common.IsgExceptionMapper.toResponse : Building 
exception response oracle.apps.fnd.soa.rt.rest.common.IsgExceptionMapper.toResponse : Error 
Message - Error while executing service oracle.apps.fnd.soa.rt.rest.common.IsgExceptionMapper.toResponse : 
oracle.apps.fnd.soa.rt.rest.common.IsgRestInvocationException: 
ServiceExecError: Error while executing service Service execution error - 
String index out of range: -2 String index out of range: -2 
at oracle.apps.fnd.soa.rt.rest.common.ErrorContext.makeRestException(ErrorContext .java:106) 
at oracle.apps.fnd.soa.rt.rest.common.ErrorContext.throwError(ErrorContext.java:88) 
at oracle.apps.fnd.soa.rt.rest.provider.IsgRestServiceProvider.serviceJSONRequest (IsgRestServiceProvider.java:652) 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.