1 Reply Latest reply on Apr 18, 2018 3:49 PM by thatJeffSmith-Oracle

    Does ORDS support returning a REF CURSOR?

    user12020272

      Hello, I think the answer is yes but I'm getting a 405 method not allowed so I just wanted to make sure. I also see conflicting information between the example I was following and the ORDS documentation:

      https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-remote-procedure-call-rpc-and-output-parameters#ref…

      https://docs.oracle.com/database/ords-17/AELIG/ORDS-reference.htm#AELIG90210

       

      The example shows they are defining the p_param_type => 'RESULTSET' in the ORDS.define_parameter call, but the docs only shows valid p_param_types as STRING, INT, DOUBLE, BOOLEAN, LONG, TIMESTAMP. So I'm a little confused.

      Can someone shed some light please?

      Thanks!!