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.


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



Invoke a web service (which has ref cursor as return type) from a rest client the below error is noticed : Building 
exception response : Error 
Message - Error while executing service : 
ServiceExecError: Error while executing service Service execution error - 
String index out of range: -2 String index out of range: -2 
at .java:106) 
at ( 
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at sun.reflect.NativeMethodAccessorImpl.invoke( 


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

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