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

Horizon Sky
Horizon Sky
in AppWorks #1

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. 

 

Tagged:

Comments

  • Michael Illarietti
    Michael Illarietti
    #2

    I have the same problem!

  • Tony Wheeler
    Tony Wheeler
    #3

    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
    Horizon Sky
    #4

    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?

     

Categories

image
OpenText CE Products
AppWorks
Gateway & Platform