From a BPM script, is it possible to call an oracle stored function returning a ref cursor?
If i have an oracle function like this:
FUNCTION getCursor( myParameter number) return sys_refcursor is
BEGIN
OPEN myCursor FOR
SELECT *
FROM myTable
WHERE field = myParameter
;
RETURN myCursor;
END;
can you share a BPM script example to call the function and read the cursor?
And is it possible create a business object based on the oracle function?
Thank you in advance.
