How to call an Oracle Stored Function returning a ref cursor?

Horizon Sky

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.

Find more posts tagged with

BPM

Comments

Michael Illarietti

I have the same problem!

Tony Wheeler

The native data access methods need to be database vendor-neutral so you won't get this out of the box, but you can certainly use the MS or Oracle provided data access libraries to work with Oracle-specific return types. This would require you to maintain your own connection, command, etc.. and close/dispose of the connection.

Horizon Sky

Thank you for the reply, but i need some details.

Read a ref cursor is a normal way to read dataset from Oracle stored procedures. So, can you share an simple example to do this within Opentext MBPM?

If i want to use my rich library of Oracle stored procedure with MBPM, what i do?