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

    Does ORDS support returning a REF CURSOR?


      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:




      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?