Problem in VB trying to use an ORDS procedure that returns a ref cursor
Summary:
Content (required):
Hi there - we are using VBCS and ORDS to connect to our database. I am trying to build a parent child select list where the child values come from a PL/SQL procedure that returns a ref cursor. As per ORDS and this blog post
we need to use POST handler while doing something like this. In postman when I run this I get the response but I need to run it with the POST method.
PROBLEM - In VB the endpoint is defined as a POST but in the select list when I use the add data option it only shows GET endpoints since I guess for the SDP it’s assuming it should be a GET endpoint. Is there any way to do this in VB where the SDP takes the POST endpoint? I cannot use a GET method in this case.